Pinned Repositories
AntBIDW-Python-ETL
An ETL package made using Python for the full and incremental loading of the Ant BI data warehouse of MVP Studio. Uses pygrametl.
auto-serverless-API-scraper
I created an AWS Lambda function in Python and deployed it using AWS CloudFormation to run on schedule, scrape information about Aussie residential listings from the Domain API, and store the data sets in an S3 bucket.
business-questions-with-SQL
This is a guided project under Dataquest (Data Engineering track) where I answered business questions about a fictional digital music store using SQL.
CIA-Factbook-Data
This is a guided project under Dataquest (Data Engineering track) where I analyzed a data set from the CIA World Factbook and provided insights on several demographic parameters.
crunchbase
I analyzed information about startup investments from Crunchbase while working with limited memory and practising the SQL/pandas workflow for handling large data sets in Python.
database-crime-reports
This is a guided project under Dataquest (Data Engineering track) where I used PostgreSQL to build a database for storing data related to crimes.
dataframe-chunks-optim
This is a guided project under Dataquest where I worked with a chunked DataFrame and optimized its memory usage.
hacker-news-posts
This is a guided project under Dataquest (Data Engineering track) where I analyzed a data set of submissions to Hacker News and determined which posts will most likely be commented and upvoted.
part-time-NSW-govt
I analysed part-time employment in the NSW State Government as part of the NSW Government Virtual Internship c/o InsideSherpa.
profitable-app-profiles
This is a guided project under Dataquest (Data Engineering track) where I was asked to provide mobile app profiles that could be profitable in Google Play and App Store markets.
bbpajarito's Repositories
bbpajarito/part-time-NSW-govt
I analysed part-time employment in the NSW State Government as part of the NSW Government Virtual Internship c/o InsideSherpa.
bbpajarito/AntBIDW-Python-ETL
An ETL package made using Python for the full and incremental loading of the Ant BI data warehouse of MVP Studio. Uses pygrametl.
bbpajarito/auto-serverless-API-scraper
I created an AWS Lambda function in Python and deployed it using AWS CloudFormation to run on schedule, scrape information about Aussie residential listings from the Domain API, and store the data sets in an S3 bucket.
bbpajarito/business-questions-with-SQL
This is a guided project under Dataquest (Data Engineering track) where I answered business questions about a fictional digital music store using SQL.
bbpajarito/CIA-Factbook-Data
This is a guided project under Dataquest (Data Engineering track) where I analyzed a data set from the CIA World Factbook and provided insights on several demographic parameters.
bbpajarito/crunchbase
I analyzed information about startup investments from Crunchbase while working with limited memory and practising the SQL/pandas workflow for handling large data sets in Python.
bbpajarito/database-crime-reports
This is a guided project under Dataquest (Data Engineering track) where I used PostgreSQL to build a database for storing data related to crimes.
bbpajarito/dataframe-chunks-optim
This is a guided project under Dataquest where I worked with a chunked DataFrame and optimized its memory usage.
bbpajarito/hacker-news-posts
This is a guided project under Dataquest (Data Engineering track) where I analyzed a data set of submissions to Hacker News and determined which posts will most likely be commented and upvoted.
bbpajarito/profitable-app-profiles
This is a guided project under Dataquest (Data Engineering track) where I was asked to provide mobile app profiles that could be profitable in Google Play and App Store markets.