数据分析

箱型图：

# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
"""

import matplotlib.pyplot as plt
import pandas as pd;
shujv = 'E:/学习/数据挖掘/data/catering_fish_congee.xls'
data = pd.read_excel(shujv,index_col='日期')
print(data.describe())

plt.rcParams['font.sans-serif']=['SimHei']
plt.rcParams['axes.unicode_minus']=False
plt.Figure()
p=data.boxplot(return_type='dict')
x=p['fliers'][0].get_xdata()
y=p['fliers'][0].get_ydata()
y.sort()
for i in range(len(x)):
if i>0:
plt.annotate(y[i], xy=(x[i],y[i]),xytext=(x[i]+0.05 -0.8/(y[i]-y[i-1]),y[i]))
else:
plt.annotate(y[i], xy=(x[i],y[i]), xytext=(x[i]+0.08,y[i]))
plt.title(3021)
plt.show()

 

 条形图、饼状图：

# -*- coding: utf-8 -*-
"""
Created on Wed Feb 22 14:15:24 2023

@author: admin
"""

import pandas as pd
import matplotlib.pyplot as plt
catering_dish_profit='E:/学习/数据挖掘/data/catering_dish_profit.xls'
data=pd.read_excel(catering_dish_profit)

x=data['盈利']
labels=data['菜品名']
plt.figure(figsize=(8,6))
plt.pie(x,labels=labels)
plt.rcParams['font.sans-serif']='SimHei'
plt.title('菜品销售量分布（饼图）3021')
plt.axis('equal')
plt.show()
print(data['盈利'].describe())

x=data['菜品名']
y=data['盈利']
plt.figure(figsize=(9,6))
plt.bar(x,y)
plt.rcParams['font.sans-serif']='SimHei'
plt.xlabel=('菜品')
plt.ylabel('销量')
plt.title('菜品销售量分布（条形图）3021')
plt.show()

 

 

 

 散点图：

# -*- coding: utf-8 -*-
"""
Created on Fri Feb 24 13:23:17 2023

@author: 25074
"""

import numpy as np
import matplotlib.pyplot as plt
x= np.linspace(0,2*np.pi,50)
y=np.sin(x)
plt.plot(x,y,'bp')
plt.title(3021)
plt.show()