Greetings to everyone.
I want to introduce a personal project in which I have been fully involved the last months.
Most of us we are ( as a analyst ) looking for a .csv from there we start to work on it.
The question that automatically appears when you feel like playing other topics is:
Q: How can I get the proper csv about a topic that i want?
my Answer: Do It by Yourself.
Since I joined Dataquest I understood that the best thing you can do is learn as much as you can from the different aspects of a project.
The first time everything was a vague idea about what the steps to follow had to be, too many things and no apparent connection, but little by little (days) I was making my way learning through hours and more hours of work and errors and more and errors solved in front of my computer.
Here are some of the technical skills I’ve touch-learned:
- Anaconda (loading enviroments, saving… )
- Linux (terminal)
- VScodium (Free/Libre Open Source Software Binaries of VS Code)
- Data bases Desing (basics)
- MySQL and MySQLWorkbench ( and problems related with snap on Ubuntu)
- Git and Github (terminal)
The project can be improved (without a doubt), the idea is to update those details ( description of functions, English translation, and more things) in the future, but now it is the time when you can show it and work on something else.
Apart from the data extraction stage, another thing I felt I needed to know was how to move the contents of a static document such as a csv to a database.
At first I was enough with SQLite, then I began to play with MySQL and finally and thanks to a book that touches on the subject of data analysis through databases I dared with PostgreSQL.
These are the Jupyters that play that part:
Now that the hard thing has passed the experience has been super positive, so I encourage everyone who wants to improve themselves to choose a topic and finish it, I hope mine will encourage you to do so.
- Finally I would like to thank the Dataquest team for the work they do and the quality of it without them I would not have been able to get here.
A&E is happy coding.