源代码(以python2.7版本为例):
#!/usr/bin/env python #coding:utf-8 import pandas as pd data=pd.read_csv("F:/py/student.csv") print 'data:' print data data2=pd.read_csv(u"F:/py/student二.csv")#打开含有中文的文件路径 print 'data2:' print data2 data3=pd.read_csv("F:/py/student3.csv",encoding="gb2312")#打开含有中文的文件 print 'data3:' print data3 data.to_pickle("F:/py/student.pickle")#存储为pickle形式的文件,注:pickle是python自带的一个文件格式,它的读写速度要比csv快,机器学习中常常用到 data2.to_pickle(u"F:/py/student二.pickle")#存储为pickle形式的文件,该文件路径含有中文 data3.to_csv("F:/py/student32.csv",encoding="gb2312")#存储为csv形式的文件,该文件含有中文 data4=pd.read_pickle("F:/py/student.pickle") print 'data4:' print data4
运行结果:
C:\Users\lhy001\PycharmProjects\untitled2\venv\Scripts\python.exe F:/py/pandastest3.py
data:
Student ID name age gender
0 1100 Abe 22 Female
1 1101 Bob 25 Female
2 1102 David 23 Female
3 1103 Kimi 21 Male
4 1104 Sakura 22 Male
5 1105 Nihonsan 22 Female
6 1106 Candy 21 Female
7 1107 France 23 Male
8 1108 Pchy 24 Female
data2:
Student ID name age gender
0 1109 Noh 24 Female
1 1110 Eivn 23 Male
2 1111 Lemon 21 Female
3 1112 Boby 23 Male
4 1113 Andy 22 Male
5 1114 Band 22 Female
6 1115 Janer 21 Male
7 1116 David 23 Male
8 1117 Coco 23 Female
data3:
Student ID name age gender
0 1100 爱贝 22 Female
1 1101 波波 25 Female
2 1102 大伟 23 Female
3 1103 凯米 21 Male
4 1104 樱 22 Male
5 1105 霓虹君 22 Female
6 1106 凯迪 21 Female
7 1107 弗兰斯 23 Male
8 1108 皮 24 Female
data4:
Student ID name age gender
0 1100 Abe 22 Female
1 1101 Bob 25 Female
2 1102 David 23 Female
3 1103 Kimi 21 Male
4 1104 Sakura 22 Male
5 1105 Nihonsan 22 Female
6 1106 Candy 21 Female
7 1107 France 23 Male
8 1108 Pchy 24 Female
Process finished with exit code 0