Python Database

Python Database

Exploring a Sqlite database with sqliteman

If you are new to databases, I recommend one of these courses:

• Master SQL Databases with Python

Python and (Relational) Database Systems:

• SQLite
• MySQL
• PostgreSQL
• ORM with SqlAlchemy

Raw data

You may need to read files or csv files, these articles will help you:

• Read file
• Write file
• Spreadsheets (csv)
• Spreadsheets (xls, xlsx)
• Read CSV files
• Read Excel

Data analysis with Pandas

The Pandas module can be used for high-performance data analysis.

• Data structures wth CSV
• Pandas read_csv
• Read xls (Excel)
• Visualize data with Pandas
• SQLite database with Pandas
• Write Excel with Pandas
• Pandas Filter