当我运行脚本时,Pandas提供以下信息:“未来警告”
FutureWarning:
Passing list-likes to .loc or [] with any missing label will raise
KeyError in the future, you can use .reindex() as an alternative.
我的剧本:
import io
data = io.StringIO('''A,B,M
AM,1,
AMC,2,
''')
df = pd.read_csv(data)
r=['CAR']
s=['CAR_M']
for i,j in zip(r,s):
df=df.append([{'A':i,'M':j}], ignore_index=True)
如果“ ignore_index = False”,将出现相同的警告。我不知道如何重新编制索引?
似乎需要Series
正确的追加新行的构造函数:
for i,j in zip(r,s):
df=df.append(pd.Series({'A':i,'M':j}), ignore_index=True)
print (df)
A B M
0 AM 1.0 NaN
1 AMC 2.0 NaN
2 CAR NaN CAR_M
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句