Python批量读取

import pandas as pd
import numpy as np
import os
os.listdir('boss压缩包')

批量读取：
file_name_list = []
for filename in os.listdir('boss压缩包'):
#     print(filename)
    if filename[-4:] == '.csv':
        file_name_list.append(filename)


file_name_list


lagou_dict={}
for filename in file_name_list:
    key = filename[:-4]
    value = pd.read_csv('boss压缩包/'+filename)
    lagou_dict[key] = value


统计每个城市有多少行数据并输出显示：
city_num = pd.Series()#建立一个空的Series
for key in lagou_dict:
    value = lagou_dict[key].shape[0]#shape[0]是看有多少行数据，shape[1]是看有多少列
    city_num[key] = value

city_num

排序大于30条数据的放入新的字典：
lagou_dict_30={}
for city in lagou_dict:
    if lagou_dict[city].shape[0]>=30:
        lagou_dict_30[city] = lagou_dict[city]

批量统计表格中的空值：
for city in lagou_dict_30:
    print(city)
    print(lagou_dict_30[city].isnull().sum())
    print('-'*30)

众数填充某列：
a = lagou_dict_30['武汉'].城市.mode()[0]#众数
#填充武汉
lagou_dict_30['武汉'].城市.fillna(a)