csv 保存多个sheet

import pandas as pd
import MySQLdb   
import csv
import random
import pymysql
import pandas as pd
import MySQLdb as mdb
import sys
import time
import os
import numpy as np
import time
import gzip
import datetime


def fun(p_list):
      writer = pd.ExcelWriter('D:\\test.xlsx')
      for i in range(len(p_list)):
            if i>100:
                  return
            m_dir  = os.path.dirname(p_list[i]) 
            m_file = os.path.basename(p_list[i])

            print("m_dir = ",m_dir)
            print("m_file = ",m_file)

            file_name = os.path.basename(m_file)
            file_name = file_name.split('.')[0]
            print(file_name)

            data1 = pd.read_csv(p_list[i], encoding="gbk")
           
            data1.to_excel(writer,sheet_name=file_name, index=0)
           
            writer.save()
      writer.close()

def walkFile_list(file):
    p_list = []
    m_count=0
    for root, dirs, files in os.walk(file):
        for f in files:
            m = os.path.join(root, f)
            ss=os.path.splitext(m)
            a = os.path.basename(m)
            if (".csv" == ss[1]):
                p_list.append(m)
            else:
                pass
    return p_list


def main():
      dir = r"E:\\"
      m_list = walkFile_list(dir)
      fun(m_list)

if __name__ =="__main__":
      print("start")
      main()

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
  
16
  
17
  
18
  
19
  
20
  
21
  
22
  
23
  
24
  
25
  
26
  
27
  
28
  
29
  
30
  
31
  
32
  
33
  
34
  
35
  
36
  
37
  
38
  
39
  
40
  
41
  
42
  
43
  
44
  
45
  
46
  
47
  
48
  
49
  
50
  
51
  
52
  
53
  
54
  
55
  
56
  
57
  
58
  
59
  
60
  
61
 

文章来源: blog.csdn.net，作者：IM-STONE，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/doubleintfloat/article/details/124501116