JDS ACADEMY - Accidents database analysis
timing of online course: March 2020 - June 2020
website: https://data36.com/
useful: Yes! Worth to complete (in Hungarian mainly).
pay-service: yes
During the course, homework had to be done with a due date, regularly in 5 days. One case an European international Accident database was in the center of a teamwork and we had to elaborate the questions and find the answers, summarize and orally present the results for the teachers of the course.
The database data was given in csv file format, including more than 10 000 entries, including AccidentID, Country, Damage (cost), nature of being reported (toward any authorities or insurance companies) and so on.
The data exploration and queries were made with the help of PostgreSQL and extracted data were plotted either in Excel or Google Sheets, finally the presentation was created in MS Power Point.
The Accidents database analysis in PDF form. English version was translated and re-styled by me.
The Jupyter Notebook and all related files on Github - Accidents analysis.
No comments:
Post a Comment