<jupyter_start><jupyter_text>Stažení souboru<jupyter_code>!wget https://mlj.solutions/biopy.xlsx
import pandas as pd<jupyter_output><empty_output><jupyter_text>Histogram<jupyter_code>data = pd.read_excel('biopy.xlsx', sheet_name='c-value all3')
data<jupyter_output><empty_output><jupyter_text>Z dat si vytvoříme DataFrame, který umožňuje jenoduché vykrelení dat<jupyter_code>from pandas import DataFrame

frame = DataFrame(data)
frame<jupyter_output><empty_output><jupyter_text>vykreslení histogramu z dataframu<jupyter_code>pd.cut(frame['C-value/birds'], 20).value_counts(sort=False).plot(kind='bar', figsize=(10,5))
pd.cut(frame['C-value/bats'], 20).value_counts(sort=False).plot(kind='bar', figsize=(10,5))
pd.cut(frame['C-value/mammals'], 20).value_counts(sort=False).plot(kind='bar', figsize=(10,5))<jupyter_output><empty_output><jupyter_text>PLOTBOX načtení nového listu "GC% all3" z excelu<jupyter_code>gc_sheet = pd.read_excel('biopy.xlsx', sheet_name='GC% all3')
gc_sheet<jupyter_output><empty_output><jupyter_text>vykreslení grafu a uložení do souboru<jupyter_code>import matplotlib.pyplot as plt

DataFrame(gc_sheet).boxplot(column=['birds.1', 'yin',	'yang',	'mammals'], patch_artist=True, figsize=(10, 5))
plt.savefig('box.png')<jupyter_output><empty_output>
StarcoderdataJupyterStructuredCleanDedup