import numpy as np
import pandas as pd
import xlrd
import openpyxl
xlsx = pd.ExcelFile('imiona.xlsx')
df = pd.read_excel(xlsx)
#A
#print(df[df['Liczba']>1000])
#B
#print(df[df['Imię'] == "CEZARY"])
#C
#print(df.agg({'Liczba':['sum']}))
#D
#x = df[((df.Rok >= 2000) & (df.Rok <= 2005))]
#print(x.agg({'Liczba':['sum']}))
#E
#chlopcy = df[((df.Płeć == "M"))]
#dziewczynki = df[((df.Płeć == "K"))]
#print(chlopcy.agg({'Liczba':['sum']}))
#print(dziewczynki.agg({'Liczba':['sum']}))
#F
for i in range(17):
x = i + 2000
x = int(x)
chlopcy = df[((df.Rok == x) & (df.Płeć == "M"))]
dziewczynki = df[((df.Rok == x) & (df.Płeć == "K"))]
print(x)
print("-------------------------------")
print(chlopcy.agg({'Liczba':['max']}))
print(dziewczynki.agg({'Liczba':['max']}))
print("-------------------------------")
#G
#chlopcy = df[((df.Płeć == "M"))]
#print(chlopcy.agg({'Liczba':['max']}))
#dziewczynki = df[((df.Płeć == "K"))]
#print(dziewczynki.agg({'Liczba':['max']}))
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}