'Cannot convert the pdf file into the CSV file
I am a new python learner, I am struggling how to change the pdf file into CSV file by using Spyder.
Input
import tabula
dfs = tabula.read_pdf(r'C:\Users\home\Desktop\RN(G)_GazetteList.pdf.pdf', pages='all')
tabula.convert_into(r'\C:\Users\home\Desktop\RN(G)_GazetteList.pdf.pdf', "output.csv", output_format="csv", pages='all')
tabula.convert_into_by_batch("input_directory", output_format='csv', pages='all')
Output
The output file is empty.
Traceback (most recent call last):
File "C:\Users\home\.spyder-py3\temp.py", line 8, in <module>
tabula.convert_into(r'\C:\Users\home\Desktop\RN(G)_GazetteList.pdf.pdf', "output.csv", output_format="csv", pages='all')
File "C:\Users\home\anaconda3\lib\site-packages\tabula\wrapper.py", line 273, in convert_into
raise FileNotFoundError(errno.ENOENT, os.strerror(errno.ENOENT), path)
FileNotFoundError: [Errno 2] No such file or directory: '\\C:\\Users\\home\\Desktop\\RN(G)_GazetteList.pdf.pdf'
Thank you so much
Solution 1:[1]
As a possible answer to serve as a reference. You could use pdftables_api
:
import pdftables_api
conversion = pdftables_api.Client('key')
conversion.csv('pdf_path','output_path')
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|---|
Solution 1 | Tkun |