pandas坑:创建df后多行数据重复

　　字典可以创建成df数据结构，但是必须传参index，否则会报错ValueError: If using all scalar values, you must pass an index。如下：

# -*- coding:utf-8 -*-
dic = {'domain': 'www.python66.com', 'author': 'dong',}
df = pd.DataFrame(dic)
print(df)

raise ValueError("If using all scalar values, you must pass an index")
ValueError: If using all scalar values, you must pass an index

　　如果传参写成了标量的形式还会报错Index(...) must be called with a collection of some kind, 0 was passed。如下：

# -*- coding:utf-8 -*-
dic = {'domain': 'www.python66.com', 'author': 'dong',}
df = pd.DataFrame(dic,index=0)
print(df)

raise cls._scalar_data_error(data)
TypeError: Index(...) must be called with a collection of some kind, 0 was passed

　　如果传参写成了列表的形式则没问题

# -*- coding:utf-8 -*-

dic = {'domain': 'www.python66.com', 'author': 'dong',}
df = pd.DataFrame(dic,index=[0])
print(df)

             domain author
0  www.python66.com   dong

　　如果传参的列表不是单个元素而是多个，结果则是重复出现同1行数据，虽然不报错，我觉得这是个坑

# -*- coding:utf-8 -*-

dic = {'domain': 'www.python66.com', 'author': 'dong',}
df = pd.DataFrame(dic,index=[0,1,2])
print(df)

             domain author
0  www.python66.com   dong
1  www.python66.com   dong
2  www.python66.com   dong

很赞哦！

python编程网提示：转载请注明来源www.python66.com。
有宝贵意见可添加站长微信(底部)，获取技术资料请到公众号(底部)。同行交流请加群