我已经创建了一个名为“df”的数据框,它看起来像这样:
Name
0. School
1. Organisation
2. Teacher
3. Guest
现在我有三个列表。
1. A = ['','','',['12','4']]
2. B = ['','','',['3','8']]
3. status = ['','','','[['yes','no','yes'],['no','yes','no']]]
4. letter = ['', '', '', [[['K', 'L'], ['L'], ['L']], [['O'], ['P', 'O'], ['K']]]]
我想将这4个列表添加到我的现有数据框df中,它应该看起来像这样。
Name A1 A2 status letter
0. School
1. Organisation
2. Teacher
3. Guest 12 3 yes K
3. Guest 12 3 yes L
3. Guest 12 3 no L
3. Guest 12 3 yes L
3. Guest 4 8 no O
3. Guest 4 8 yes P
3. Guest 4 8 yes O
3. Guest 4 8 no K
我已经尝试过 df['from']=from
和 df['to']=to
,但是这并没有给我期望中的表格。
我也尝试了以下方法:
dfa=pd.DataFrame({"Names":names})
def flat(nums):
res = []
index = []
for i in range(len(nums)):
if isinstance(nums[i], list):
res.extend(nums[i])
index.extend([i]*len(nums[i]))
else:
res.append(nums[i])
index.append(i)
return res,index
x="A1"
list_flat,list_index=flat(eval(x))
dataframe = pd.DataFrame({x:list_flat},index=list_index)
df = pd.concat([df['Names'],dataframe],axis=1,sort=False)
x="A2"
list_flat,list_index=flat(eval(x))
dataframe = pd.DataFrame({x:list_flat},index=list_index)
df= pd.concat([df,dataframe],axis=1,sort=False)
x="status"
list_flat,list_index=flat(eval(x))
dataframe = pd.DataFrame({x:list_flat},index=list_index)
df = pd.concat([df,dataframe],axis=1,sort=False)
x="letter"
list_flat,list_index=flat(eval(x))
dataframe = pd.DataFrame({x:list_flat},index=list_index)
df = pd.concat([df,dataframe],axis=1,sort=False)
但是,嵌套列表并没有像不同的行一样出现,而是像这样出现在同一行。
Name A1 A2 status letter
0. School
1. Organisation
2. Teacher
3. Guest 12 3 ['yes','no','yes'] [['K','L'],['L'],['L']]
3. Guest 4 8 ['no','yes','no'] [['O'],['P','O'],['K']]
letter
是二维的? - Jeril