import pandas as pd # pandas package를 이용
sample1 = pd.read_excel("http://kanggc.iptime.org/book/data/stat-1.xlsx")
sample1

sample1.info()

mid = sample1['mid']
final = sample1['final']
total = sample1['total']
grade = sample1['grade']

#frequencies of each value in grade
#grade.value_counts()
print("Frequency of Grade is : ",f'\n{grade.value_counts()}\n')

import matplotlib.pyplot as plt # matplotlib.pyplot package를 이용
import seaborn as sns # seaborn packagem를 이용

# 한글이 깨지지 않게 하기
import matplotlib
from matplotlib import  font_manager, rc 
font_path = "C:/Windows/Fonts/malgun.ttf"
font = font_manager.FontProperties(fname=font_path).get_name() 
rc('font', family=font)
matplotlib.rcParams['axes.unicode_minus'] = False 

data = [4, 11, 11, 16, 9, 5, 3, 1]
keys = ['1등급','2등급','3등급','4등급','5등급','6등급','7등급','8등급']
  
# define Seaborn color palette to use
palette_color = sns.color_palette('bright')
  
# plotting data on chart
plt.pie(data, labels=keys, colors=palette_color, autopct='%.0f%%')
plt.title("Pie Chart of Test Score")  
# displaying chart
#plt.show()

plt.savefig('C:/BOOK/PyBasics/PyStat/code/pie.png')