Python and Excel by using openpyxl
This post will show a very interesting thing that can be done by using Python and Excel together with a GUI that creates an application. At my workplace we often must extract or clean data, one example is shown below:
In the third column which is named “target” we can see text but also numbers, the meaning of this post is to create a fast way to extract these numbers.
The picture above comes from the dashboard that contains data from twitter concerning the Swedish Tax Agency, “Skatteverket”, that I created.
I used Python and R in this project. Python was used to download around 4 2000 old tweets that mentions “Skatteverket”, I was able to do this by using the package GetOldTweets3 in Python.
I used R and the package Rtweet to download data from the official account of Skatteverket.
The picture above is from the live dashboard that I created.
This was a fun project for me because I learned so much and used many different tooltips! The mission was to extract data from a website that contains information on figure skaters from all over the world.
I used Python in order to scrape the data by using Beautiful Soup and Pandas, I also cleaned the data in Python.