Data and ML

Aditya Tiwari

4 followers

I'm a Data and ML enthusiast. I thrive on the thrill of transforming raw data into actionable solutions that drive real-world results. Let's embark on a data driven journey together!

Parquet batch ingestion with Python, Postgres and Docker.

Jan 27, 20244 min read

Introduction We'll use Python to ingest into a Postgres database the NYC TLC green taxi trip records for September 2019, which are available in a...

Parquet batch ingestion with Python, Postgres and Docker.

Ingesting and visualizing data using Python and Postgres

Jan 1, 20243 min read

We'll ingest the NYC taxi zone lookup data into a postgres database through a postgres container and visualize it using python, pandas, sqlalchemy and...

Ingesting and visualizing data using Python and Postgres

Modeling and Transforming data for analytics using SQL, Dbt and AWS Redshift.

Nov 16, 20235 min read

Introduction I'll be going through a hypothetical scenario at an event ticketing company and describe the data modeling and transformation process in...

Modeling and Transforming data for analytics using SQL, Dbt and AWS Redshift.