python - 如何使用python将不同长度的列表插入excel文件？

Question

How to insert list of different length to excel file using python?

import pandas as pd
df = pd.DataFrame()

list1=["a","b","c"]
list2=["d","e","f","g"]

df['col1'] = list1
df['col2'] = list2

df.to_excel('output.xlsx',index = False)

Expected Output:

col1   col2
a      d
b      e
c      f
       g

Answer 1

将 list 转换为 pd.Series 并使用 pd.concat

import pandas as pd
df = pd.DataFrame()

list1=pd.Series(["a","b","c"])
list2=pd.Series(["d","e","f","g"])

df = pd.concat([list1,list2], ignore_index=True, axis=1)

df.to_excel('output.xlsx',index = False)

输出:

     0  1                                                                                                                                      
0    a  d                                                                                                                                      
1    b  e                                                                                                                                      
2    c  f                                                                                                                                      
3  NaN  g