csv与xlsx文件相互转化

一.xlsx转化为csv

#!/usr/bin/env python
# -*- coding:utf-8 -*-
# author : jin  time :2019/3/5

import pandas as pd

def xlsx_to_csv(path):
    data_xlsx = pd.read_excel(path,  index_col = 0) #index_col = 0 第一列不为索引
    data_xlsx.to_csv('此处为包含csv文件的路径', encoding = 'utf-8')
    print('xlsx文件已经转化为csv文件')

if __name__ == '__main__':
    path = '此处为包含xlsx文件的路径'  #如 'C:\\Users\\1\\Desktop\\text\\example.xlsx'
    xlsx_to_csv(path)

二.csv转化为xlsx

#!/usr/bin/env python
# -*- coding:utf-8 -*-
# author : jin  time :2019/3/5

import pandas as pd

def csv_to_xlsx(path):
    csv = pd.read_csv(path, encoding = 'utf-8')
    csv.to_excel('此处为包含xlsx文件的路径', sheet_name = 'data') #sheet_name仅仅改变sheet的name
    print('csv文件已经转化为xlsx文件')

if __name__ == '__main__':
    path = '此处为包含csv文件的路径'
    csv_to_xlsx(path)