Damn, that was awesome! I can only imagine, what goes through your head, when you simply write lines of code like if it was normal sentence and it actually works! Well done, you've deserved your like and subscribe.
Thank you man soo much earlier i was working with PyPDF2 but it was not providing proper spacing while reading the file but with the help of pdfplumber i fixed this issue. and now code is running completely fine. Thanks man for helping with the name of library
Thank you dude! I finally found a real tutorial that helps me on my way getting data out of a pdf that Isn’t easy and well structured. I have another problem that you aren’t facing here. My invoice has items that are split on multiple pages and I need to figure out how to assign that data from the second page to the invoice item of the page before!
That’s a fun challenge - similar to when you have multiple lines you want to assign to one. You have a variable that tracks where you are in the page / document, and use that to determine when to combine / assign info as needed.
@@PythonicAccountant yes, I’m hyped to test it tomorrow, I tried some other libraries too, but none of them worked for me. In the first place I wanted to do it with OCR but quickly found out that there are easier options when the pdf is searchable :D but I also face an other Problem where the PDF isn’t searchable and these pdfs contain handwritten text + copied invoices, I worked with easyOCR at some point in a different project but it‘s not working for me right now
Bro... you saved me AF... I was trying to get data from a PDF and export that data to .csv or .xlsx and I was about to die trying to solve it :p. BTW I'm very new in scripting. Cheer from Argentina. You deserve millons of likes and suscriptors! (now I'm one of them)
Wow fantastic video! Very informative and shows how to parse PDFs in the real world! Well done. This will help me learn about Pythonic parsing from various data sources. Please make equivalent for MS Word docx files. Thank you! 👍
Love it...I'm new to python...learning as I want to do some data analysis on a dataset that can only be generated in a poorly laid out pdf (don't ask why!) So this a great intro / guide to some fantastic functions which gives me hope :-)
This is very helpful, thank you. I was wondering, is there a way to search for properties besides the text itself? For example, say every vendor number is always highlighted in blue, or it's always bold and a larger font size, or it is always directly above a thick horizontal line. Is there a way for PDF plumber to search for the text that matches those particular properties?
Absolutely fantastic video. Quick question I have, what changes would you make to the syntax if the PDF consists of let's say 350 pages or more with the same form of data across the pdf? That would be the biggest help. Thank you
Thanks for the question! The only change id make is to start a list, and iterate through each page in the pdf, appending the resulting extract to the list. That would only hold one pdf page in memory at once, and the list wouldn’t get that big.
Awesome ! Thanks for such a informative session, can you please continue the nlp lectire on data extractions from diff files like json, webscrapping,and pdf
I do have several on the web scraping, and more PDFs, so check out my other videos! I don’t have too much on JSON but I do have a lot of experience working with that format, so can certainly look at adding some videos on that!
Great tutorial! I agree, it’s the best tutorial I found d so far when working with unstructured PDF files. I have a question although my docs are not invoices but forms. Some of these PDFs have graphics, i.e., blue circles/elipses to “select” the best answer to some questions. Is there a way to identify these graphics and then select the text enclosed in them? If needed, I can share one of PDF so you can see what I mean. TIA
This is super helpful. Thank you so much for sharing. One question that I have is on missing values. I see that your invoice happens to have no missing values for the columns . What if I have missing values in few columns. Is it possible to read those missing/ blank values of the table also while reading the text to maintain consistency of columns.
Very informative thanks. I have a problem though in constructing a regular expression where the invoice may have a "Disc Amount" or not. At this time the expression assumes it is always blank.
Thank you! Perfect explained, easy to follow your code. I have a question, related Hebrew/Arabic languages. When extracting the text, it's reversed. How can I fix it? Thank you!
Extremely helpful and easy. I'm looking to extract transaction details from bank or credit card statements for analysis say 3yrs and need to come up with spending pattern or project style of spending in each category. The data in statement contains different boxes and views. Would like to see if you any videos
Amazing video! Thank you for posting! Just curious, is it possible to extract vendor # and invoice # as well, although some is empty in pdf? I have a similar problem here with a Xero journal report. The debit and credit figures are in two separate columns and not sure how to use RE to tell which number is debit, and which is credit.
Yep that’s a challenge but can usually be done. There are ways to use spacing to determine which is from which column but it gets a little tricky sometimes. If you want to send a sample page with any sensitive data redacted, I’d be happy to give it a shot - pythoniccpa@gmail.com
@@PythonicAccountant I lied about one thing: It's a lot above my head! Haha. But, there's literally never been a better time to learn, especially with resources like this.
Thank you so much. I am working with a 100 pages pdf file. I did your codes, but only 5 rows of data from 1 page were exported to the df. all of the pages are extracted. is there any solution?
excellent series, so useful!!! If you can, do one where someone can upload a pdf of a balance sheet and it returns a data frame of all the entries ( the column names could be "entry type(assets, liabilities...)", "entry name(ppl, inventory, retained earnings)", "value")
Fantastic video! It just solved my work problem easily! But I also tried to extract description which is in a line after all the invoice line items. I am not sure how to get the description and append it as the last column in the DataFrame. i have found no text pattern for the description, cant use re.compile to fetch. Could you tip me on that pls?
You can usually grab descriptions not based on the pattern of the description itself, but the pattern of everything around it. For example if there are three sets of numbers that always show up before the description, then use those three numbers of the pattern to determine that the description is coming next. If you want to send me a redacted example I could try and take a look - pythoniccpa@gmail.com
Teres Lok can have a flag for that. Maybe “in_line_item = False”. When your regex picks up that you’re in the line items change it to “in_line_items = True”. Then each iteration of a new line, of in_line_items AND the regex doesn’t match a line item, you know you’re now in the first line after the line items, which is your description line.
This Reg Expressions is the Army Swiss Knife on steroids. Is it used for Web Scraping in your experience ? Is there another Library you know of that is a jewel like this in the toolbox. I feel like I'm gulping from a River that is flowing with Pure Water.
I have the same scenario as you with the vendor number and vendor name. How do I get it to print all vendors and not just the one on the last page? How do I use regex if my vendor number and name is separated by a hyphen? For example, 700 - Smith, Joe. Sorry I’m a python newb
Can we make something different if not a complete spreadsheet is given to us to extract data from, but if we generate such PDFs upon the transaction and we want to create a script that could directly take those generated PDFs from the chrome browser and manage to gather the name,invoice no.,date and the amount ,amount + gst= total amount,and then format them into a spreadsheet and finally make a sheet which could include the total amount collected at the end of the day or when specificed by the user. Hope it won't be difficult as it looks eagerly waiting for your reply.
Of course, regex doesn’t care what profession it’s supporting :) The biggest factor is whether you are dealing with a scanned PDF or a computer generated PDF. If it is computer-generated then you need to make sure the text you’re trying to capture is not in an image. If the PDF is scanned, or you are trying to capture data from an image, then you will need to use a different approach than just regex, as you’ll need to perform OCR. One way to do that is with Tesseract, but there are other options as well.
Thanks Steven! I learned pretty much everything I know about python through a few Coursera courses, a few python books, and some of the TalkPython trainings. Then it was just a bunch of playing around and having fun. All hands on, and trying to solve problems. Lost of googling also, that’s a programmer’s best friend no matter how experienced. I’ve included the code for most of these videos on github at github.com/danshorstein/pythonic-accountant
Not sure if it is needed to do so, as every invoice is actually generated by the data system, so it should be in excel format at the very beginning, why don't we use SQL to generate all the info ?
Wow. find this cool tutorial after struggling with with pricy proprietary app. Btw, how to extract more than one line as single value. for instance there is an invoice with 3 lines in its description. Thank you.
Absolutely doable! Takes a few extra steps, particularly taking some steps to identify what row you are in and when you reach a last row that you need to combine all the data. I will keep this in mind for a future video
For me, in the xlsx file, date are being rendered as ######## with the message of 'possible error loss' in excel. Any idea why? (My dataframe looks completely fine) How shall I resolve, thanks!
Awesome Tutorial. Really informative, and I learnt a lot. I have a question, suppose say i have a list of application forms (pdfs/images) in which users fill them by handwritten. say "Name: _________ " Here Name: is going to be in Computer Printed text, but the blank is filled with handwritten text. And there are multiple fields that are need to be extracted with the similar issue. How can i get the the data extracted from these?
Best bet is using OCR, with something like tesseract. Here’s an example of one of many tutorials that can help with that www.pyimagesearch.com/2017/07/10/using-tesseract-ocr-python/
But that ocr (tesseract) is for only optical characters like the digital types text only right? I don't think that can be used for handwritten text detection
Hari Vamsi oh right, that’s different. Much more difficult and I haven’t done much with that, but think tensorflow or PyTorch could be your best bets for building a handwriting recognition model. Something like link.medium.com/QkxEiMcJN6
This Content is Priceless indeed. Thank you for taking time out and create such a resourceful video step by step with detailed narration. However, I have a PDF which does not contain tabular data. It contains text data which I need to convert it into .csv excel tabular form. Can you help me with it please?
@@PythonicAccountant: I have sent you an email for the same, so please do have a look and suggest me the modifications I need to make for solving my problem statement
In comparison to pdfminer how do you evaluate pdfplumber? Is it possible to draw black boxes on the pdf specific parts by using pdfplumber? As I had a short glance, it seems pdfplumber doesn't write the result into a pdf unlike pdfminer, but it seems it keeps the structure of pdf unlike pdfminer which is very helpful. Any ideas?
I found that by opening a pdf file with Mozilla Firefox and inspecting it with the developer tools you can collect its text (with the help of JavaScript) after the web browser has converted it to HTML and maybe save it for further processing with someone programming language.
Yeah there are quite a few ways to get the text from PDF file, it’s just a matter of whether you need it to maintain information about where the text is on the page, and if you need to create an automated process versus manually clicking, that’ll impacts what method ends up being the best.
Damn, that was awesome! I can only imagine, what goes through your head, when you simply write lines of code like if it was normal sentence and it actually works! Well done, you've deserved your like and subscribe.
Thank you!!
Incredibly talented. The way you graciously remedied, remolded, and reimagined the landscape of that PDF report.
Inspired.
I am just mesmerised by the way you are playing around with python script and regex. Mind blowing!
Sir, I have no words to express my gratitude for this video. That was exactly what I needed. Thank you!
YES! This is excellent! I am eight hours in on reports which I was loading into pdf2xl and finishing with PowerQuery. LOVE THIS!
Great!
Thank you man soo much earlier i was working with PyPDF2 but it was not providing proper spacing while reading the file but with the help of pdfplumber i fixed this issue. and now code is running completely fine. Thanks man for helping with the name of library
pdfplumber has worked well when PyPDF2 doesnt
Superb detail and very straight forward. Thank you for showing me your workflow and insightful guide to parsing semi-structured data
Thanks!
Thank you dude! I finally found a real tutorial that helps me on my way getting data out of a pdf that Isn’t easy and well structured. I have another problem that you aren’t facing here. My invoice has items that are split on multiple pages and I need to figure out how to assign that data from the second page to the invoice item of the page before!
That’s a fun challenge - similar to when you have multiple lines you want to assign to one. You have a variable that tracks where you are in the page / document, and use that to determine when to combine / assign info as needed.
@@PythonicAccountant yes, I’m hyped to test it tomorrow, I tried some other libraries too, but none of them worked for me. In the first place I wanted to do it with OCR but quickly found out that there are easier options when the pdf is searchable :D but I also face an other Problem where the PDF isn’t searchable and these pdfs contain handwritten text + copied invoices, I worked with easyOCR at some point in a different project but it‘s not working for me right now
Now I convinced to learn regex and lambda to extract text from pdf, thank you!
WOW!! You are on fire with this code man! That was awesome!
Bro... you saved me AF... I was trying to get data from a PDF and export that data to .csv or .xlsx and I was about to die trying to solve it :p. BTW I'm very new in scripting.
Cheer from Argentina. You deserve millons of likes and suscriptors! (now I'm one of them)
Glad to help!!
Excellent! Thanks a lot for taking the effort to solve a realistic problem!
Thank you so much Pythonic Accountant for sharing your awesome skills in this video, it helped me a lot!
My pleasure, thanks for watching!
Execellent Tutorial - thank you for sharing 👏
You are a literal Grandmaster.
Very nice approach to solving this kind of problem. Thank you.
Wow fantastic video! Very informative and shows how to parse PDFs in the real world! Well done. This will help me learn about Pythonic parsing from various data sources. Please make equivalent for MS Word docx files. Thank you! 👍
Love it...I'm new to python...learning as I want to do some data analysis on a dataset that can only be generated in a poorly laid out pdf (don't ask why!) So this a great intro / guide to some fantastic functions which gives me hope :-)
Awesome! Enjoy the journey!
This is very helpful, thank you. I was wondering, is there a way to search for properties besides the text itself? For example, say every vendor number is always highlighted in blue, or it's always bold and a larger font size, or it is always directly above a thick horizontal line. Is there a way for PDF plumber to search for the text that matches those particular properties?
dude i was just looking for something like this and this video saved me hours of work. Awesome content, thanks for sharing!
Glad I could help!
Absolutely fantastic video. Quick question I have, what changes would you make to the syntax if the PDF consists of let's say 350 pages or more with the same form of data across the pdf? That would be the biggest help. Thank you
Thanks for the question! The only change id make is to start a list, and iterate through each page in the pdf, appending the resulting extract to the list. That would only hold one pdf page in memory at once, and the list wouldn’t get that big.
@@PythonicAccountant Cool Cool 👊
Very nice! Thank you for sharing!!
I'm so glad I just found this channel. Haven't watched yet but Thank you
Awesome ! Thanks for such a informative session, can you please continue the nlp lectire on data extractions from diff files like json, webscrapping,and pdf
I do have several on the web scraping, and more PDFs, so check out my other videos! I don’t have too much on JSON but I do have a lot of experience working with that format, so can certainly look at adding some videos on that!
Awesome - difficult example done with ease. Thanks for sharing knowledge.
Thank you so much for your explaination
This video was very helpful. Thank you very much.
Very cool, thanks for making this video
You bet!
This video is amazing! Thank you!
Thanks, that was really helpful. Only a short side-note that you should have zoomed the screen to make it more readable.
This is so damn awesome. Great work
Thanks!!
@@PythonicAccountant I’m trying to extract data nested table from pdf, is it possible for you to make a video on how to do that?
Awesome video!
Thanks!
Thanks for the videos, this has been extremely helpful!
Hello, that it recommended me to use in Python 3.9; Thank you.
It’s always best practice to use the most current version of python available.
Amazing video, thank you so much!
Great tutorial! I agree, it’s the best tutorial I found d so far when working with unstructured PDF files. I have a question although my docs are not invoices but forms. Some of these PDFs have graphics, i.e., blue circles/elipses to “select” the best answer to some questions. Is there a way to identify these graphics and then select the text enclosed in them? If needed, I can share one of PDF so you can see what I mean. TIA
This is super helpful. Thank you so much for sharing. One question that I have is on missing values. I see that your invoice happens to have no missing values for the columns . What if I have missing values in few columns. Is it possible to read those missing/ blank values of the table also while reading the text to maintain consistency of columns.
Good question!
Wonderful video. Thanks much
Thanks!
Excellent!!
Many thanks!
Excellent ...
Thanks a lot man 👍
Thank you so much? Is data scraping easier via word than via pdf, would you say?
It depends on the structure and what you’re trying to get out of it.
Excellent !!! Great video !!!
Thank you! Cheers!
Good Tutorial, Does it works for Bularian PDF as well. Does it supports other Crllic languages as well
Very informative thanks.
I have a problem though in constructing a regular expression where the invoice may have a "Disc Amount" or not.
At this time the expression assumes it is always blank.
Superb. ❤
Thanks!
Thank you! Perfect explained, easy to follow your code. I have a question, related Hebrew/Arabic languages. When extracting the text, it's reversed. How can I fix it? Thank you!
line = line[::-1] # reverses order of the text
@@PythonicAccountant Works!!!!! Thank you very much!
Sooo cool 😁
Thanks!
Extremely helpful and easy. I'm looking to extract transaction details from bank or credit card statements for analysis say 3yrs and need to come up with spending pattern or project style of spending in each category. The data in statement contains different boxes and views. Would like to see if you any videos
Amazing video! Thank you for posting! Just curious, is it possible to extract vendor # and invoice # as well, although some is empty in pdf? I have a similar problem here with a Xero journal report. The debit and credit figures are in two separate columns and not sure how to use RE to tell which number is debit, and which is credit.
Yep that’s a challenge but can usually be done. There are ways to use spacing to determine which is from which column but it gets a little tricky sometimes. If you want to send a sample page with any sensitive data redacted, I’d be happy to give it a shot - pythoniccpa@gmail.com
@@PythonicAccountant Just sent. Thank youuuuu!!!
enjoy! ua-cam.com/video/P_ECMWfA3MU/v-deo.html
cool 👏
waowwwwwwwww!!!!! that's sick!
I think AI Builder in Power Automate is becoming a viable alternative to using Python for this. This is a little above my head, but thank you.
Thanks I’ll have to check that out
@@PythonicAccountant I lied about one thing: It's a lot above my head! Haha. But, there's literally never been a better time to learn, especially with resources like this.
@@daveg5857 haha you’ll get there, just practice and have fun!
It's good, but I have a doubt if we want dynamically then how it will work because I think re is Checking the particular number of range
Noiiiiiiceeee
Thanks!
TY 😀
You bet!
An amazing way to extract data with regex.
Btw, what editor are you using?
just what I was looking for, Thank You
How did you fix that error on 8:07? because I also get the same error
So cool
thanks man u are amazing! keep it up!
Amazing!!!
It was very helpful,thank you for sharing!!
This is great
great tutorial, thanks!
Hey, Excellent video.Can you make a video on extracting text from multiple documents at once.Thanks
I have a pre-downloaded pdf to work with. But I get this erroe when I try to read the pdf: PDFSyntaxError: No /Root object! - Is this really a PDF?
Thank you so much.
I am working with a 100 pages pdf file. I did your codes, but only 5 rows of data from 1 page were exported to the df. all of the pages are extracted. is there any solution?
Really depends on a lot of factors, you’d need to do some debugging and looking at the format to see why it’s missing the rest
excellent series, so useful!!! If you can, do one where someone can upload a pdf of a balance sheet and it returns a data frame of all the entries ( the column names could be "entry type(assets, liabilities...)",
"entry name(ppl, inventory, retained earnings)", "value")
Great Tutorial
Great material, thank you!
One question....can you add the invoice number against each line item too?
As long as it’s in the data and can be identified / extracted from its pattern, definitely.
Fantastic video! It just solved my work problem easily! But I also tried to extract description which is in a line after all the invoice line items. I am not sure how to get the description and append it as the last column in the DataFrame. i have found no text pattern for the description, cant use re.compile to fetch. Could you tip me on that pls?
You can usually grab descriptions not based on the pattern of the description itself, but the pattern of everything around it. For example if there are three sets of numbers that always show up before the description, then use those three numbers of the pattern to determine that the description is coming next. If you want to send me a redacted example I could try and take a look - pythoniccpa@gmail.com
@@PythonicAccountant thank you for the prompt reply^^. Unfortunately, there is only the description in the line, nothing else around it :(
Teres Lok That makes it even easier! Just grab the whole line and that’s your description!
Pythonic Accountant how could I specify the description line right after the invoice line? I’m stuck here😢
Teres Lok can have a flag for that. Maybe “in_line_item = False”. When your regex picks up that you’re in the line items change it to “in_line_items = True”. Then each iteration of a new line, of in_line_items AND the regex doesn’t match a line item, you know you’re now in the first line after the line items, which is your description line.
This Reg Expressions is the Army Swiss Knife on steroids. Is it used for Web Scraping in your experience ? Is there another Library you know of that is a jewel like this in the toolbox. I feel like I'm gulping from a River that is flowing with Pure Water.
awesome , thx!!!!!!!
I wish to be you! Great skill!
Incredible work! Congrats! Do you think it's possible to extract a nonpattern text from a PDF file and move it to another text file?
Yes, as long as there’s a way to identity which portion of text you want to grab
I have the same scenario as you with the vendor number and vendor name. How do I get it to print all vendors and not just the one on the last page? How do I use regex if my vendor number and name is separated by a hyphen? For example, 700 - Smith, Joe. Sorry I’m a python newb
Can we make something different if not a complete spreadsheet is given to us to extract data from, but if we generate such PDFs upon the transaction and we want to create a script that could directly take those generated PDFs from the chrome browser and manage to gather the name,invoice no.,date and the amount ,amount + gst= total amount,and then format them into a spreadsheet and finally make a sheet which could include the total amount collected at the end of the day or when specificed by the user.
Hope it won't be difficult as it looks eagerly waiting for your reply.
Can we do the same for medical forms? Regex does not seem to work for that.
Of course, regex doesn’t care what profession it’s supporting :) The biggest factor is whether you are dealing with a scanned PDF or a computer generated PDF. If it is computer-generated then you need to make sure the text you’re trying to capture is not in an image. If the PDF is scanned, or you are trying to capture data from an image, then you will need to use a different approach than just regex, as you’ll need to perform OCR. One way to do that is with Tesseract, but there are other options as well.
This is amazing! Could you use this code if you wanted to grab text from multiple pages in a PDF?
This is amazing! Thanks for posting! How did you learn coding like this? By hands on? Do you have a web site or blog where we can get the codes?
Thanks Steven! I learned pretty much everything I know about python through a few Coursera courses, a few python books, and some of the TalkPython trainings. Then it was just a bunch of playing around and having fun. All hands on, and trying to solve problems. Lost of googling also, that’s a programmer’s best friend no matter how experienced. I’ve included the code for most of these videos on github at github.com/danshorstein/pythonic-accountant
Sincerely thank you! Great learning repository for individuals like me! Please keep posting!
When you are as brilliant as this guy, everything is easy :). The code is in the github link above.
Not sure if it is needed to do so, as every invoice is actually generated by the data system, so it should be in excel format at the very beginning, why don't we use SQL to generate all the info ?
This is Awesome!!!
Wow. find this cool tutorial after struggling with with pricy proprietary app.
Btw, how to extract more than one line as single value. for instance there is an invoice with 3 lines in its description.
Thank you.
Absolutely doable! Takes a few extra steps, particularly taking some steps to identify what row you are in and when you reach a last row that you need to combine all the data. I will keep this in mind for a future video
@@PythonicAccountant that would be awsome, i have the same problem, a "cell" in a table with more than one row
is it somehow possible to use python to find and LOCATE Mathematical equations in PDF's?
Amazing tutorial, my question is: "is there any method in python for doing same with scanned images as well like .png, jpg etc..."
Hey Sibhat, yes, but it is a little different. It’s basically the same as using a scanned PDF file. I’ll try and do a video on that soon.
@@PythonicAccountant, Extracting original layout of any scanned document and exporting it to word, excel what ever is easy :)
@@PythonicAccountant sir plz make the video on this
Harshita Gupta here you go! ua-cam.com/video/glJi3LBgn9U/v-deo.html
Please Ihave many invoices each one with different structure of line items, sometimes you find first description qunatity ...
I have a really complex pdf table that i have to read. Would you mind helping me with it?
For me, in the xlsx file, date are being rendered as ######## with the message of 'possible error loss' in excel. Any idea why? (My dataframe looks completely fine) How shall I resolve, thanks!
Thank you so much! Could you please share the code 🙏
github.com/danshorstein/pythonic-accountant/tree/master/015%20Extract%20line%20items%20from%20PDF%20AP%20listing
Awesome Tutorial. Really informative, and I learnt a lot.
I have a question, suppose say i have a list of application forms (pdfs/images) in which users fill them by handwritten. say "Name: _________ " Here Name: is going to be in Computer Printed text, but the blank is filled with handwritten text. And there are multiple fields that are need to be extracted with the similar issue.
How can i get the the data extracted from these?
Best bet is using OCR, with something like tesseract. Here’s an example of one of many tutorials that can help with that www.pyimagesearch.com/2017/07/10/using-tesseract-ocr-python/
But that ocr (tesseract) is for only optical characters like the digital types text only right? I don't think that can be used for handwritten text detection
Hari Vamsi oh right, that’s different. Much more difficult and I haven’t done much with that, but think tensorflow or PyTorch could be your best bets for building a handwriting recognition model. Something like link.medium.com/QkxEiMcJN6
This Content is Priceless indeed. Thank you for taking time out and create such a resourceful video step by step with detailed narration.
However, I have a PDF which does not contain tabular data. It contains text data which I need to convert it into .csv excel tabular form. Can you help me with it please?
It’s doable but more challenging for sure.
@@PythonicAccountant: I have sent you an email for the same, so please do have a look and suggest me the modifications I need to make for solving my problem statement
In comparison to pdfminer how do you evaluate pdfplumber? Is it possible to draw black boxes on the pdf specific parts by using pdfplumber? As I had a short glance, it seems pdfplumber doesn't write the result into a pdf unlike pdfminer, but it seems it keeps the structure of pdf unlike pdfminer which is very helpful. Any ideas?
Check out the method im.draw_rect(bbox_or_obj, fill={color}, stroke={color}, stroke_width=1) from github.com/jsvine/pdfplumber
@@PythonicAccountant Awesome, thanks.
Hi,
In tabula,
Is it possible to get page number from which we got dataframe
Thanks in advance
I found that by opening a pdf file with Mozilla Firefox and inspecting it with the developer tools you can collect its text (with the help of JavaScript) after the web browser has converted it to HTML and maybe save it for further processing with someone programming language.
Yeah there are quite a few ways to get the text from PDF file, it’s just a matter of whether you need it to maintain information about where the text is on the page, and if you need to create an automated process versus manually clicking, that’ll impacts what method ends up being the best.
why didn't you capture the invoice number?
Probably didn’t think of it :)
How can we print a line on the basis of a word we are searching for in the pdf?
If word in line:
print(line)
See i have pdf and from that pdf i want to extract the task name and only the time taken by them
Hi, i'd like to aoly to a table where every cell has many rows of text, i cannot use this method cuz the multilines in every cell of the table
Can use this model for invoice image structure extraction?
I’m not exactly sure what you’re looking to do, can you clarify with an example?