python 读写excel、读写csv

import pandas as pd

注意：xlrd == 1.2.0

	安装方法：pip install xlrd==1.2.0

1、读excel

def readExcel():
    # 默认读取sheet1
    data1 = pd.read_excel("source-excel.xlsx")


    # 指定sheet名(工作表名），获取Sheet2
    data2 = pd.read_excel("source-excel.xlsx", sheet_name="Sheet2")

    # 指定sheet索引(工作表索引，索引从0开始），获取sheet2
    data3 = pd.read_excel("source-excel.xlsx", sheet_name=1)

    print(data1)
    print(data2)
    print(data3)

source-excel.xlsx文件数据形式，另文章顶部 python-读写excel、csv源文件包含源文件

data1 返回结果

	sheet1-c1 sheet1-c2
	0    s1-1-1    s1-2-1
	1    s1-1-2    s1-2-2
	2    s1-1-3    s1-2-3
	3    s1-1-4    s1-2-4
	4    s1-1-5    s1-2-5
	5    s1-1-6    s1-2-6
	6    s1-1-7    s1-2-7
	7    s1-1-8    s1-2-8
	8    s1-1-9    s1-2-9

data2、 data3 返回结果

  sheet2-c1 sheet2-c2
0    s2-1-1    s2-2-1
1    s2-1-2    s2-2-2
2    s2-1-3    s2-2-3
3    s2-1-4    s2-2-4
4    s2-1-5    s2-2-5
5    s2-1-6    s2-2-6
6    s2-1-7    s2-2-7
7    s2-1-8    s2-2-8
8    s2-1-9    s2-2-9

2、保存excel

def saveExcel():
    data = pd.DataFrame(data = [
        ['s1 - 1 - 1',    's1 - 2 - 1'],
        ['s1 - 1 - 2',    's1 - 2 - 2'],
        ['s1 - 1 - 3',    's1 - 2 - 3'],
        ['s1 - 1 - 4',    's1 - 2 - 4'],
        ['s1 - 1 - 5',    's1 - 2 - 5']
    ], columns=["col1", "col2"])

		# 保存文件
    writer = pd.ExcelWriter('source-excel-save.xlsx')
    # index=False 不保留索引
    data.to_excel(writer, "Sheet1", index=False)
    writer.save()

data1 返回结果

	sheet1-c1 sheet1-c2
	0    s1-1-1    s1-2-1
	1    s1-1-2    s1-2-2
	2    s1-1-3    s1-2-3
	3    s1-1-4    s1-2-4
	4    s1-1-5    s1-2-5
	5    s1-1-6    s1-2-6
	6    s1-1-7    s1-2-7
	7    s1-1-8    s1-2-8
	8    s1-1-9    s1-2-9

data2、 data3 返回结果

  sheet2-c1 sheet2-c2
0    s2-1-1    s2-2-1
1    s2-1-2    s2-2-2
2    s2-1-3    s2-2-3
3    s2-1-4    s2-2-4
4    s2-1-5    s2-2-5
5    s2-1-6    s2-2-6
6    s2-1-7    s2-2-7
7    s2-1-8    s2-2-8
8    s2-1-9    s2-2-9

3、读csv

def readCsv():
    # 默认读取sheet1
    data1 = pd.read_csv("source-csv.csv")
    print(data1)

source-csv.csv文件数据形式，另文章顶部 python-读写excel、csv源文件包含源文件

data1 返回结果

	sheet1-c1 sheet1-c2
	0    s1-1-1    s1-2-1
	1    s1-1-2    s1-2-2
	2    s1-1-3    s1-2-3
	3    s1-1-4    s1-2-4
	4    s1-1-5    s1-2-5
	5    s1-1-6    s1-2-6
	6    s1-1-7    s1-2-7
	7    s1-1-8    s1-2-8
	8    s1-1-9    s1-2-9

4、保存csv

def saveCsv():
    data = pd.DataFrame(data = [
        ['s1 - 1 - 1',    's1 - 2 - 1'],
        ['s1 - 1 - 2',    's1 - 2 - 2'],
        ['s1 - 1 - 3',    's1 - 2 - 3'],
        ['s1 - 1 - 4',    's1 - 2 - 4'],
        ['s1 - 1 - 5',    's1 - 2 - 5']
    ], columns=["col1", "col2"])

    data.to_csv('source-csv-save.csv', index_label="Sheet1", index=False)