pandas存储csv,txt
数据准备
import numpy as np
import pandas as pd
year = np.arange(1949,2022,1)
number = np.linspace(0,1,len(year))
years = pd.DataFrame(year,columns=['年'])
numbers = pd.DataFrame(number,columns=['number'])
data = pd.concat([years,numbers],axis=1) #连接两个DataFrame
data.to_csv('data.csv')
此时存储顺利,但出现了中文乱码问题
解决存时中文乱码问题
data.to_csv('data.csv',encoding='utf_8_sig')
去掉前面行索引
data.to_csv('data.csv',encoding='utf_8_sig',index=False)
存储为txt–默认为 , 间隔
修改间隔–以空格为间隔
data.to_csv('data.txt',sep=' ',index=False)
Pandas读取csv,txt
读取csv
data = pd.read_csv('data.csv')
读取txt
data = pd.read_csv('data.txt')
读取txt时,以,为分割导致所有元素在一列
以空格为分割读取
data = pd.read_csv('data.txt',sep=' ')
当空格分布不规则时,用正则表达式
data = pd.read_csv('data.txt',sep='\s+')