python - 将新行附加到现有数据框

Question

我试图将新记录插入到数据框中，但收到此错误 - DataFrame 构造函数未正确调用。

这是我的代码，

import pandas as pd

#defining the dataframe
dfHeader = { 'Name': [], 'Daily': [],'Weekly': [],'Monthly': [],'Yearly': [],
             'Area': [], 'Latitude':[] , 'Longitude':[] ,'Amenity': [] }

dFrame = pd.DataFrame(dfHeader)
print(dFrame)
Name = "NA"
DailyPrice = "NA"
WeeklyPrice = "NA"
MonthlyPrice = "NA"
YearlyPrice = "NA"
Area = "NA"
latitude = "NA"
longitude = "NA"
Amenity = "NA"

row = (Name, DailyPrice, WeeklyPrice, MonthlyPrice, YearlyPrice, Area, latitude, longitude, Amenity)

print(row)

dFrame = dFrame.append(pd.DataFrame(row))

请帮我解决这个问题。

Answer 1

如果您需要添加单行:

In [136]: dFrame.loc[len(dFrame)] = row

In [137]: dFrame
Out[137]:
  Amenity Area Daily Latitude Longitude Monthly Name Weekly Yearly
0      NA   NA    NA       NA        NA      NA   NA     NA     NA

注意:通常，首先将数据收集到列表列表中，然后调用 pd.DataFrame() 构造函数，通常会更好、更快、消耗更少的内存(这取决于......) >一次:

In [138]: data = [row, np.arange(9)]

In [139]: cols = 'Amenity Area Daily Latitude Longitude Monthly Name Weekly Yearly'.split()

In [140]: df = pd.DataFrame(data, columns=cols)

In [141]: df
Out[141]:
  Amenity Area Daily Latitude Longitude Monthly Name Weekly Yearly
0      NA   NA    NA       NA        NA      NA   NA     NA     NA
1       0    1     2        3         4       5    6      7      8