在datafram的[0]位置插入行

Question

我有一个像这样的框架，在那里我插入一个新行

import pandas as pd

s1 = pd.Series([5, 6, 7])
s2 = pd.Series([11, 12, 13])
s3 = pd.Series([22, 23, 24])

index_lst = ['StockA','StockB','StockC']

df = pd.DataFrame([list(s1), list(s2), list(s3)],  columns =  ["A", "B", "C"], index = index_lst)
insert_line = pd.DataFrame({'A' : 99, 'C' : 98}, index = ['NewStock'])
df2 = pd.concat([df.ix[0:], insert_line])

这给了我这个

^{pr2}$

如何将“NewStock”条目插入第0行？我要这个订单

           A     B   C     
NewStock  11   nan  22   
StockA     5  6.00   7  
StockB    11 12.00  13 
StockC    22 23.00  24 

Answer 1

如果它们都是数据帧，我想你可以使用pd.concat()。在

所以也许是这样？在

import pandas as pd

s1 = pd.Series([5, 6, 7])
s2 = pd.Series([11, 12, 13])
s3 = pd.Series([22, 23, 24])

index_lst = ['StockA','StockB','StockC']

df = pd.DataFrame([list(s1), list(s2), list(s3)],  columns =  ["A", "B", "C"], index = index_lst)
insert_line = pd.DataFrame({'A' : 99, 'C' : 98}, index = ['NewStock'])


df = pd.concat([insert_line, df])