Project
Convoy Shipping Company
Challenging
209 completions
~ 25 hours
4.4You will learn how to export data from an XLSX file to a CSV format. You will prepare the data to populate an SQLite database. You will learn how scoring machines are built, and how to select which data should be exported to other systems (in JSON and XML formats).
Provided by
JetBrains Academy
About
You're employed at "Convoy", a family transport company. Things are not going well financially, so your bosses want you to create a database to manage the company's assets in a better way and introduce scoring machines to automate some work. You will be dealing with different file formats to export data to various systems.
Training project
This project allows you to practice and strengthen your coding skills, helping you get ready for more advanced tasks ahead.
What you'll learn
Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:
Convert an XLSX to a CSV file and check the results.
Correct the data for future calculations.
Populate your SQLite3 database with the corrected data.
Export your data from an SQLite3 database to the JSON format.
Export your data from an SQLite3 database to the XML format.
Implement scoring machines and export your data from SQLite3 to external files.
Reviews
6 months ago
I learned a lot about using pandas to convert data between formats (Excel, CSV, SQL, JSON, XML), and to clean and analyze data.
Margarita Prikhodkova
1 year ago
Nice project to learn how to work with all sorts of file formats that can actually be useful in real projects
Andres Nicolas Zarta
2 years ago
How to use the different data formats to retrieve and modify persistent data.
4.4
Learners who completed this project within the Python Developer course rated it as follows: