pandas读写csv和xlsx

import pandas as pd

import numpy as np

1、读写csv

path = '.../111.csv'

读
data = pd.read_csv(path, index_col=0)    index_col为标题的序号

写
list1 = [[1, 1, 1, 1], [2, 2, 2, 2]]
dt1 = pd.DataFrame(list1)
dt1.to_csv(path, mode='w')    //w为一次性写入，a可多次添加

2、读写xlsx

path = '.../111.csv'

写
list1 = [[1, 1, 1, 1], [2, 2, 2, 2]] 
dt1 = pd.DataFrame(list1) 
dt1.to_excel(path)

读
data = pd.read_excel(path, index_col=0)
print(data)
转换成列表
data_array = np.array(data) 
data_list = data_array.tolist()
print(data_array)
print(data_list)