import pandas as pd url = "http://www.sejm.gov.pl/Sejm9.nsf/agent.xsp?symbol=glosowania&NrKadencji=9&NrPosiedzenia=18&NrGlosowania=1" df = pd.read_html(url, encoding='utf-8')[0] columns = [c for c in df.columns.to_list() if c!="Klub/Koło"] objects = [x for x in columns if df[x].dtype==object and x!="Klub/Koło"] def obj_to_int(df,columns): for c in columns: df[c] = df[c].map(lambda x: 0 if x=="-" else int(x)) return df df2 = obj_to_int(df, columns) print(df2) df2.to_csv("sejm.csv")