import camelot
import pickle
import pandas as pd

from PyPDF2 import PdfFileReader
pdf = PdfFileReader(open('Report.pdf','rb'))

dataframes=[]
for page in range(1,pdf.getNumPages()+1):
    print('Reading page', page)
    df=camelot.read_pdf('Report.pdf',pages='%d'%page)[0].df
    dataframes.append(df)
    

pickle.dump( dataframes, open( "save.p", "wb" ) )

# for frame in df:
#     dataframe =df[0].df
#     headers = dataframe.iloc[0]
#     new_df  = pd.DataFrame(dataframe.values[1:], columns=headers)
#     print(new_df.columns)