A challenge that uses PostgreSQL to perform data engineering for the employee database.
-
Updated
Oct 12, 2020
A challenge that uses PostgreSQL to perform data engineering for the employee database.
Employees data analysis using SQL, SQL Alchemie and Pandas.
As a Data Engineer, collect employee data from the 1980s to the 1990s and determine its trend on each employee's salaries, titles, and departments.
Design tables to hold employee data in csvs, import csvs into a SQL database and analyze data ~ data engineering, modeling and analysis
In this assignment, you will design the tables to hold data in the CSVs, import the CSVs into a SQL database, and answer questions about the data. In other words, you will perform: Data Engineering & Data Analysis
Using the Open Weather Map, Google Nearby Search, and Google Place Search APIs to obtain climate data; using gmaps to create visualisations of selected cities' climate and hotel location data.
Automated assistance for the schema development lifecycle
Datasette plugin for uploading CSV files and converting them to database tables
Ex 1 - Run timed quizzes via the command line
A blazing fast fully-automated CSV to database importer
Add a description, image, and links to the csvs topic page so that developers can more easily learn about it.
To associate your repository with the csvs topic, visit your repo's landing page and select "manage topics."