Work Examples - Create Your Application
What:
Read image-links and check if there are copyright violations in the internet. Show this violations as
links to the page.
Used Modules:
requests, serpapi, PIL, imagehash, xlwings
What:
Read the main text of any webpage and output the data in an excel-sheet. Links are provided in the
excel-sheet and the output in an additional column.
Used Modules:
trafilatura, xlwings
What:
Read links and search with them on ask.com, translate them from any language to english and store
the informatino in excel. Executeable for MacOs.
Used Modules:
requests, bs4, deep_translator, xlwings
What:
Read football-statistics from a ms-access-db and provide the data in an
excel-sheet. Select several parameters before the program run like leagaue coffeeAndBeer
date-range
Used Modules:
pyodbc, xlwings
What:
Create all possible combinatons for a lottery with 70 numbers and 5 number per
row - write the 11Mio rows in a csv
Used Modules:
csv, itertools
What:
Input: searchwords and textfiles - Output: Count every searchword in the textfiles, the domain ending and
output the results in excel
Used Modules:
xlwings, urllib
What:
Read the text for given urls in an excel and detect the language of the website, output the results in
excel
Used Modules:
trafilatura, xlwings, selenium, detectlanguage
What:
Parse contract-informations, and build a summary overview, input percentages for every employee and
detailed contract informations
Used Modules:
xlwings
What:
Read persons and provisions and build the output according to the titles, create a summary docx for
every person
Used Modules:
xlwings, docx
What:
Collect data for companies with searchwords as input and find emails additonal.
Input will be the link to search - Output in excel
Used Modules:
selenium, bs4, xlwings, valueserp, emailfinder
What:
Check findings for urls on google maps and output fouund link, full address, category, rating, review, city, country, etc.
Used Modules:
selenium, bs4, xlwings, fake_useragent
What:
Run the program every few minute and check machine downtimes, register special downtimes and get an
hourly statistics output
Used Modules:
xlwings
What:
Get name+company and find linkedin-profile with title
Used Modules:
requests, valueserp, xlwings
What:
Create a working plan for creating beds and other furniture - select article, parameterize the step and create a working plan including pictures for the individual steps
Used Modules:
xlwings
What:
Read excel-attachements from emails, change the excel-sheet and upload it to a ftp-server
Used Modules:
email, imap_tools, ftplib, xlwings, dotenv