Advertisement
HabKaffee

Untitled

Apr 21st, 2021
1,061
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.25 KB | None | 0 0
  1. import pandas as pd
  2. import numpy as np
  3. import matplotlib.pyplot as plt
  4. import seaborn as sns
  5. import plotly.express as px
  6. wb = load_workbook('/content/drive/My Drive/Colab Notebooks/table_to_proga.xlsx')
  7.  
  8. sheet = wb['institutions_csv']
  9.  
  10. fifthColumn = list()
  11.  
  12. for i in range(2,343): #range от 2 до 343 потому что мы заполняем таблицу по i, row и col должны быть больше 0. Берем со 2 индекса, потому что в 1 строке хранится название каждого столбца
  13.  
  14.      fifthColumn.append(sheet.cell(row=i, column=5).value)
  15.  
  16. d = dict.fromkeys(fifthColumn_set,0)
  17. for item in fifthColumn:
  18.     d[item] +=1
  19.  
  20. #print (d)
  21. #print(fifthColumn_set)
  22.  
  23. arr = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 34, 35, 38, 40, 41]
  24. arrVal = [8,7,11,13,10,6,10,12,23,1,13,23,20,38,2,10,12,16,1,15,9,19,34,10,3,7,2,2]
  25.  
  26. fig, ax = plt.subplots()
  27. explode = (0,0,0,0,0,0,0,0,0,0,0,0,0,0.2,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
  28. plt.figure(figsize=(20,10), dpi=500)
  29. ax.pie(arrVal, labels = arr, explode=explode)
  30. ax.axis("equal")
  31. print('Диаграмма, показывающая соотношение значений в графе "Stratification cell"')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement