# pip pip install camelot-py # conda conda install -c conda-forge camelot-py import camelot tables = camelot.read_pdf('foo.pdf', pages='1', flavor='lattice') print(tables) tables.export('foo.csv', f='csv', compress=True) tables[0].to_csv('foo.csv') # to a csv file print(tables[0].df) # to a df # from website import pandas as pd simpsons = pd.read_html('https://en.wikipedia.org/wiki/List_of_The_Simpsons_episodes_(seasons_1%E2%80%9320)') # getting the first 5 rows of the table "Season 1" (second table) simpsons[1].head()
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter