PYTHON

#1.read del/dat import pandas as pd data=pd.read_csv(path+'//test.del',engine='python',header=0,delimiter='',names=["id","name"],nrows=10)#header=0表示第一行是标题行 #2 read_pickle data=pd.read_pickle(path+"//test.pkl") data.to_pickle(path+'//test.pkl') #存储 #3 read_csv data=pd.read_csv(path+"test.csv",engine="python",encoding="gbk",mode='a') #mode=a,代表可以追加数据 #4 read txt data=pd.read_table(path+"test.txt",header=None,dtype={'a':str}) # 5 read sas import sas7bdat as sa data=sa.SAS7BDAT(path+"//test.sas7bdat",encoding='gb2312').to_data_frame().drop_duplicates() #6.读取db2数据库 import db2_conn engine=db2_conn.conn() sql_test="select * from table fetch first 10 rows only" data=pd.read_sql(sql=sql_test,con=engine) # 7.读取sqlite 数据库 import sqlite3 cx=sqlite3.connetct(path+"test.db") sql_test="select * from table limit 10" data=pd.read_sql(sql_test,cx) cx.close()