Portfolio – Automate PDF

What:
Encrypt pdf files according to clients-codes with defined password per client in an excel-sheet

Used Modules:
PyPDF2, xlwings

What:
Read pdf and check which checkboxes are checked / unchecked. Write the results with the text in ouput- dataframe

Used Modules:
pdfplumber, pandas

What:
Parse PDFs for water supply documents with type, use, manufacturer, year built, inspect type, location, etc.

Used Modules:
pdfplumber, xlwings

What:
Read pdf and parse the address information with name, street, city, zip and write the data to an excel-sheet

Used Modules:
pdfplumber, xlwings

What:
Search for workcodes, download the pdfs, merge them and store them

Used Modules:
selenium, bs4, pypdf2, xlwings

What:
Parse all radio-buttons in the PDF-document if they are selected or not, and the input fields format the document. Data is summarized in an excel-sheet.

Used Modules:
pdfplumber, xlwings

What:
Read a pdf-form and create for every entry in an excel-sheet a individual pdf-file

Used Modules:
fillpdf, xlwings

What:
Get table data from a pdf and structure this in different worksheets in excel

Used Modules:
pdfplumber, xlwings

What:
Parse data from pdf invoices and provide the data row by row in an excel-sheet eg. For final amoun and terms of payment

Used Modules:
pdfplumber, xlwings

What:
Parse data from orders for different liquors and different customers with different informations

Used Modules:
pdfplumber, xlwings

What:
Parse data from pdfs for energy informations for houses and provided this data in batch in an excel-sheet

Used Modules:
pdfplumber, xlwings

What:
Parse pilot-data from different flights with several information and match them to pairs in excel

Used Modules:
pdfplumber, xlwings

What:
Read email, check for attachements and parse the data from the pdfs to an invoice

Used Modules:
imap_tools, pdfplumber, xlwings