根据csv表生成柱状图_excel数据统计并生成图表脚本

# -*- coding:utf-8 -*-

import csv
import numpy as np
import matplotlib.pyplot as plt
import sns as sns
from matplotlib.ticker import FuncFormatter
from matplotlib.ticker import PercentFormatter
import pandas as pd
import sys


def data_processing():
    # 1.填写要筛选的excel表格
    df = pd.read_csv("./query-hive-327549.csv")
    # 2.填写筛选条件model=PCDM10 ， package=com.tencent.tmgp.sgame ，key7=30 ，range=（0,30）
    model = 'PCDM10'
    package = 'com.tencent.tmgp.sgame'
    fps = 30
    key = 30
    df1 = df.loc[(df['model'] == model) & (df['package'] == package)]
    # print(df1)
    df2 = df1.loc[(df1['range'] <= fps) & (df1['key7'] == key)]
    # print(df2)
    # 3.计算 range=xx -> hit_count_sum(xx)/hit_count_sum
    sums = df2['hit_count'].sum(