成功的利用pandas库进行表格数据筛选后合并

——————————————————————————————————————————————————————————————————————

成功的利用pandas库进行表格数据筛选后合并

import csv
import os
import numpy as np
import pandas as pd
import matplotlib
import matplotlib.pyplot as plt
def not_empty(s):
   return s and s.strip()
#os.chdir("E:/fdtq76")#目标目录
path="E:/fdtq76"
allfile=[]
def getallfile(path):
   allfilelist=os.listdir(path)
   for file in allfilelist:
      filepath=os.path.join(path,file)
      allfile.append(filepath)
   return allfile
Data=[]
def read(files):
   #i=len(files)
   i=0
   for item in files:
      if i<len(files):
         data = pd.DataFrame(pd.read_csv(item))
         #print(type(data))
         data=data.iloc[0:144,:]
         #print(data)
         Data.insert(i,data)
         i+=1
      else:
         print(len(Data))
   result=pd.concat(Data)
   print(result)
   return result
files=getallfile(path)
f=read(files)
print(type(f))
pd.DataFrame(f).to_csv('E:/abc.csv')