pandas读取csv写入mysql_Pandas操作数据库及保存csv

数据的保存

import pandas as pd

import numpy as np

from pandas import Series

col_db = [['one',1,2,3,4,np.nan],['two',5,6,8,'world',np.nan],['three',9,10,11,12,'foo']]

data = pd.DataFrame(col_db,columns = ['somthing','a','b','c','d','message'])

data

somthingabcdmessage

0one1234NaN

1two568worldNaN

2three9101112foo

# 利用DataFrame的to_csv方法,csv默认为逗号分隔

data.to_csv('save.csv')

# 指定分隔符

data.to_csv('save_.csv',sep='|')

# 缺失值在输出结果中会被表示为空字符串，你可以指定

data.to_csv('save_1.csv',na_rep='NULL')

# 禁用行和列的标签，只保留数据

data.to_csv('save_2.csv',header=False,index=False)

# 输出指定的列，并以指定的顺序排列

data.to_csv('save_2.csv',index&