python数据框追加_将行追加到Pandas数据框将添加0列

附加正在尝试将列附加到数据帧。它试图追加的列没有命名，其中有两个None/Nan元素，pandas将(默认情况下)命名为列0。

若要成功执行此操作，数据帧追加中的列名必须与当前数据帧列名一致，否则将创建新列(默认情况下)#you need to explicitly name the columns of the incoming parameter in the append statement

df = DataFrame(columns=['col1', 'col2'])

print df.append(Series([None]*2, index=['col1','col2']), ignore_index=True)

#as an aside

df = DataFrame(np.random.randn(8, 4), columns=['A','B','C','D'])

dfRowImproper = [1,2,3,4]

#dfRowProper = DataFrame(arange(4)+1,columns=['A','B','C','D']) #will not work!!! because arange returns a vector, whereas DataFrame expect a matrix/array#

dfRowProper = DataFrame([arange(4)+1],columns=['A','B','C','D']) #will work

print df.append(dfRowImproper) #will make the 0 named column with 4 additional rows defined on this column

print df.append(dfRowProper) #will work as you would like as the column names are consistent

print df.append(DataFrame(np.random.randn(1,4))) #will define four additional columns to the df with 4 additional rows

print df.append(Series(dfRow,index=['A','B','C','D']), ignore_index=True) #works as you want