pytho统计csv列不同次数_python csv统计某一列的频率，插入图表

# 环境依赖

pip install xlsxwriter

# 环境依赖

# pip install xlsxwriter

import csv

import os

import xlsxwriter

def count_list(list_data):

"""统计列表数值频率"""

from collections import Counter

result = Counter(list_data)

return dict(result)

def list_data(data):

# d = {'dd': 3, '11': 22}

ret = list()

for key, val in data.items():

ret.append([key, val])

return ret

class ReadCsv(object):

def __init__(self):

pass

def read_all(self, file_name):

"""读取所有"""

import csv

result = list()

with open(file_name, encoding='utf-8') as f:

reader = csv.reader(f)

for rows in reader:

result.append(rows)

return result

def read_col(self, filename, col_name):

"""读取某一列"""

with open(filename, 'r', encoding='utf-8') as file:

reader = csv.DictReader(file)

column =