I am trying to take this data and turn it into a dataframe in pandas:
I am using camelot and it is "working" however, I am only getting 2 columns with this code:
import camelot
tables = camelot.read_pdf('Inventory_Summary.pdf', flavor='stream')
print(tables[0])
what is happening is it is considering everything on the left side 1 columns and the blacked out information the only information in the 2nd column
I want just the informaiton below the date into a dataframe
any help you can provide whould be great!
Thanks!
-littlejiver