The information from two csv files, companies.csv and financial.csv, will be imported to two database tables that hold company information as so:
companies database table:
- ticker TEXT PRIMARY KEY
- name TEXT
- sector TEXT
financial database table:
- ticker TEXT PRIMARY KEY
- ebitda REAL
- sales REAL
- net_profit REAL
- market_price REAL
- net_debt REAL
- assets REAL
- equity REAL
- cash_equivalents REAL
- liabilities REAL
The user will have the option to perform CRUD (Create, Read, Update, Delete) operations on these two database tables, or list the top companies based on certain analysis made on the financial information available for each company.
You will get familiar with basic SQL commands, learn how to read files and create databases, and find out how to read, update, and delete fields in the database.
To learn more about this project, please visit HyperSkill Website - Calculator for Investors.
This project's difficulty has been labelled as Challenging where this is how HyperSkill describes each of its four available difficulty levels:
- Easy Projects - if you're just starting
- Medium Projects - to build upon the basics
- Hard Projects - to practice all the basic concepts and learn new ones
- Challenging Projects - to perfect your knowledge with challenging tasks
This repository contains:
data repository - Contains the 2 csv files from which data were imported into database tables
analysis.py - Contains the implementation of this program's aim using SQLAlchemy library
analysis_2.py - Contains the implementation of this program's aim using sqlite3 library
Project was built using python version 3.11.3
Download the project's files (data repository, analysis_2.py and analysis.py) to your local repository and open the project in your choice IDE and run either analysis_2.py or analysis.py. Both programs will provide the same user interface, but will differ in implementation.
After a single run of the program, a database investor.db would have been created in the same working directory.