填充
我在没有标题的文本文件中有数据。每行的值都有一个标签,指示它们属于哪个列。我想以这些标签为列名,并在列下馈送数据。
我想从文本文档导入以下内容(请注意列下的值的排列不是恒定的(:
Column1=variable11&Column2=variable12&Column3=variable13&Column4=variable14
Column2=variable22&Column1=variable12&Column3=variable23
Column1=variable13&Column3=variable33&Column2=variable32&Column4=variable34&Column5=variable35
我希望结果是这样的表:
Column1 Column2 Column3 Column4 Column5
variable11 variable12 variable13 variable14
variable21 variable22 variable23
variable31 variable32 variable33 variable34 variable35
您可以使用pandas dataframes:
import pandas as pd
a='''Column1=variable11&Column2=variable12&Column3=variable13&column4=variable14
Column2=variable22&Column1=variable12&Column3=variable23
Column1=variable13&Column3=variable33&Column2=variable32&Column4=variable34&Column5=variable35'''
result = []
for line in a.split('n'):
dict_line = {}
for chunk in line.split('&'):
col, var = chunk.split('=')
dict_line[col] = var
result.append(dict_line)
pd.DataFrame(result)
将返回您的数据框:
Column1 Column2 Column3 Column4 Column5 column4
0 variable11 variable12 variable13 NaN NaN variable14
1 variable12 variable22 variable23 NaN NaN NaN
2 variable13 variable32 variable33 variable34 variable35 NaN
此数据框中的空单元格被NaN