【遍历csv文件统计各列数目并输出单个文件】

GUAI_GUAI_daydayup

已于 2022-08-05 10:55:36 修改

阅读量312

点赞数

文章标签： python pandas 开发语言

于 2022-08-04 19:56:00 首次发布

本文链接：https://blog.csdn.net/qq_58291072/article/details/126165651

版权

   # print(a.groupby(['H_F_MDS_QC']).count())
import os
import numpy as np
import pandas as pd

# import pandas as pd
# c1= [1,1,1,1]
# c2 = [2,2,2,2]
# c3= [3,3,3,3]
# #use pandas
# #write date by using the form of dict
# df= pd.DataFrame({'column1':c1,'column2':c2,'column3':c3})
# df.to_csv("test1.csv",index=False)


def solecol_count(path,out_path):
    dic1=[]
    dic2=[]
    dic3=[]
    dic4=[]
    dic5=[]
    dic6=[]
    dic7=[]
    dic8=[]
    dic9=[]
    # dic10=[]
    dic11=[]
    dic12=[]
    dic13=[]
    dic14=[]
    # dic15=[]
    dic16=[]
    dic17=[]
    dic18=[]
    dic19=[]
    dic20=[]
    dic21=[]
    dic22=[]
    dic23=[]
    dic24=[]
    dic25=[]
    dic26=[]
    dic27=[]
    dic28=[]
    dic29=[]
    dic30=[]
    dic31=[]
    dic32=[]
    dic33=[]
    dic34=[]

    
    for i in os.listdir(path):
        a=pd.read_csv(os.path.join(path, i))
        
        a.replace(-9999,np.nan,inplace=