我有一个csv数据文件,其中有两个标题,这意味着一个标题作为一个问题和第二个作为一个子标题,其中有多个层次或答案的主要标题。当前csv如下表所示
Header Which country do you live? Which country you previously visited? Users Canada USA UK Mexico Norway India Singapore Pakistan User 1 Canada Singapore User 2 UK India User 3 Mexico Pakistan User 4 Norway India
我需要把它转换成下表
Users Which country do you live? Which country you previously visited? User 1 Canada Singapore User 2 UK India User 3 Norway Pakistan User 4 Mexico India
有人能帮我吗?你知道吗
首先用} 删除第二级
bfill
填充缺少的值,然后选择第一列并用^{MultiIndex
:编辑:
相关问题 更多 >
编程相关推荐