@查看.csv文件出现OSError: Initializing from file failed问题[TOC]
源代码:
import pandas as pd
#创建序列
s1 = pd.Series([‘小明’, ‘李红’, ‘阿辉’, ‘萌萌’, ‘小李’, ‘小黄’, ‘小华’])
s2 = pd.Series([‘男’, ‘女’, ‘男’, ‘女’, ‘男’, ‘男’, ‘男’])
s3 = pd.Series([18, 20, 17, 22, 21, 25, 19])
s4 = pd.Series([165, 176, 177, 154, 180, 167, 166])
s5 = pd.Series([45, 56, 42, 70, 56, 66, 57])
s6 = pd.Series([90, 88, 78, 97, 45, 32, 67])
s7 = pd.Series([90, 88, 78, 97, 45, 32, 80])
#创建数据集
df=pd.DataFrame(
{
‘名字’:s1,
‘性别’:s2,
‘年龄’:s3,
‘身高’:s4,
‘体重’:s5,
‘语文’:s6,
‘数学’:s7
})
df.to_csv(‘d:\学生信息表.csv’,index=None,encoding=‘utf-8’) #以CSV形式保存
df=pd.read_csv(‘d:\学生信息表.csv’) #加载数据集
df
运行结果:
解决办法:
在pd.read_csv(‘文件路径’)后面加上engine=‘python’,encoding=‘utf-8’
如图所示:
运行结果:
好了,这样问题就解决了,有问题可以继续探讨哦!删除线格式