---
title: "Aditya Tiwari (@adi07) | Hashnode"
description: "Data Science and MLOps Enthusiast. Read the latest articles by Aditya Tiwari on Hashnode."
url: "https://hashnode.com/@adi07"
---

@adi07

# Aditya Tiwari

@adi07 · India · Joined July 2023

Data Science and MLOps Enthusiast

### [Parquet batch ingestion with Python, Postgres and Docker.](https://dataml.hashnode.dev/parquet-batch-ingestion-with-python-postgres-and-docker?utm_source=hashnode&utm_medium=feed)

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 file at the following URL:(https://d37ci6vzurychx.cloudfront.net/trip-data/green\_tripdata\_2019-0...

4 min read · [dataml.hashnode.dev](https://dataml.hashnode.dev/parquet-batch-ingestion-with-python-postgres-and-docker?utm_source=hashnode&utm_medium=feed)

[Jan 27, 2024](https://hashnode.com/posts/parquet-batch-ingestion-with-python-postgres-and-docker/65b56460ab26f78fd0bd61d2)

### [Ingesting and visualizing data using Python and Postgres](https://dataml.hashnode.dev/ingesting-and-visualizing-data-using-python-and-postgres?utm_source=hashnode&utm_medium=feed)

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 matplotlib. This setup allows us to use the best analytical capabilities of both SQL and Pandas. Th...

3 min read · [dataml.hashnode.dev](https://dataml.hashnode.dev/ingesting-and-visualizing-data-using-python-and-postgres?utm_source=hashnode&utm_medium=feed)

[Jan 1, 2024](https://hashnode.com/posts/ingesting-and-visualizing-data-using-python-and-postgres/6592ce8ecbd083815d642d99)

### [Modeling and Transforming data for analytics using SQL, Dbt and AWS Redshift.](https://dataml.hashnode.dev/modeling-and-transforming-data-for-analytics-using-sql-dbt-and-aws-redshift?utm_source=hashnode&utm_medium=feed)

Introduction I'll be going through a hypothetical scenario at an event ticketing company and describe the data modeling and transformation process in the STAR format. The github repository of the project is linked below.(https://github.com/Aditya-Tiw...

5 min read · [dataml.hashnode.dev](https://dataml.hashnode.dev/modeling-and-transforming-data-for-analytics-using-sql-dbt-and-aws-redshift?utm_source=hashnode&utm_medium=feed)

[Nov 16, 2023](https://hashnode.com/posts/modeling-and-transforming-data-for-analytics-using-sql-dbt-and-aws-redshift/6556a6e3f38a2fd784dab0e6)
