How Python helped me analyze a database, look in the web and aggregate new data to perform a deeper analysis, write my findings into a report in Word, prepare a presentation in PowerPoint, share the documents through Outlook…
…And all without pressing a single key of my keyboard.
Since these activities can be scalable to most work-related tasks, every step was performed, extracted, reported and presented within Microsoft Office Software, including the mailing task.
For this exercise, I chose a relatively small database that records wine consumption, describing information from each bottle, as well as a score indicating the consumer preference in a range from 1 to 5, where one is bad and five es very good.
Note: You will find some information in Spanish, if you are not related to this language don’t worry, I will do my best to explain each point in English.
The base structure without any data would look something like this:
As you can see, nothing very sophisticated just enough to collect 12 types of information from each bottle:
