Google Colab as a Platform for Data Engineering & Analytics
A Monthly Recap of Google Colab Articles, Tutorials, Videos, etc.
![](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/f638c7a3-54b7-4e57-b0ca-bd93dcc3b720/enric-domas-iD4r0bm0ZDU-unsplash.jpg)
Terraform an Athena Database on Google Colab
Using Google Colab, Terraform & the AWS CLI to setup a simple database using S3 for storage, the Glue Catalog and Crawlers for automatically detecting and documenting the schema, and finally Athena for executing basic queries.
![Portfolio Statistics with Java, Jupyter & YahooFinance](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1676491492956-3T36UEJFOTQ3ZOUT2JIL/corner_the_market.png)
Portfolio Statistics with Java, Jupyter & YahooFinance
Using the unlikely pairing of Tablesaw for Java & Jupyter Notebooks (Google Colab), we’ll review very basic techniques for calculating portfolio statistics. Yahoo Finance will provide the Financial Data Sets for our analysis.
![YahooFinance with Tablesaw (Java) and Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1676490475919-JANG4PJS3U1A1JZX93ET/yahoo_finance.png)
YahooFinance with Tablesaw (Java) and Google Colab
Use Java and a YahooFinance Client to download and analyze Financial Datasets with a popular DataFrame library (Tablesaw).
April 2022
![Terraform a Database for Financial Statements using Amazon Athena & Glue](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1659815412173-5P7EIMXKA80AV4JQZ251/ahmer-kalam-STJJ6OR3F1c-unsplash.jpg)
Terraform a Database for Financial Statements using Amazon Athena & Glue
Quickly create a database using Amazon Web Services to store the Financial Statements we plan to use to create the world’s next best money pit…
![Query Financial Statements from SEC Data using Tablesaw for Java](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1659814263291-RY0Y80H1UXUP3M4ELJZ8/patrick-weissenberger-uJhgEXPqSPk-unsplash.jpg)
Query Financial Statements from SEC Data using Tablesaw for Java
Use Tablesaw for Java to Build Dataframes for Analyzing Balance Sheets, Income & Cash Flow Statements, etc.
![IO Parquet with Java on Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1649268957411-JF6IX643KCYV0Y7XB3W6/yellow-taxi-gd6597cdf1_1920.jpg)
IO Parquet with Java on Colab
Read/Write Parquet with Tablesaw in Java on Google Colab (Jupyter).
![Line Charts with D3 on Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1647412026890-NX5O1BI1KV30Y52N6S5B/taxi_and_line_chart_v2.png)
Line Charts with D3 on Google Colab
Simple Line Charts with D3 on Google Colab Notebooks
February 2022
January 2022
![Data Viz with D3 in Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1643226854380-TUK0V8V61SC6LDKREW3L/1_7iM__hI-OnqT0wKsfTX0xw.png)
Data Viz with D3 in Google Colab
Getting Started with D3 on Google Colab Notebooks
![Java, Jupyter and Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642279274397-NCAPEYB9UKOEIG3D038V/cropped_1_iu-pHM5L8waP4q3OiSKLWQ.png)
Java, Jupyter and Google Colab
Using Java on Google Colab (Jupyter)
![Getting Started with Dataframes using Java and Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642279186226-JN25F39NXZK9K0WJELSK/cropped_1_6NlKuMBUCrHjT9zRac6kFQ.png)
Getting Started with Dataframes using Java and Google Colab
Working with Dataframes using Java and Google Colab (Jupyter)
![Dataframes with Tablesaw — CSV Files](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642277673561-2K3FF9GEYB6DOM4TQ9J2/photo-1523961131990-5ea7c61b2107.jpg)
Dataframes with Tablesaw — CSV Files
Some simple examples of how to download, import/export, & query CSV data using Java on Google Colab (Jupyter).
![Java, Jupyter & Plotly](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642278636233-WP5XY237O2IWTGZ5FD9W/cropped_1_esp8gLQNYfo8yQ-qrozBBw.png)
Java, Jupyter & Plotly
Using a Java Wrapper for Plotly to create Visualizations for Google Colab Notebooks (Jupyter) running with a Java Kernel
![Dataframes & JSON with Java on Jupyter](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642279051883-D71IFZTH4SYPDHEG26GB/cropped_ferenc-almasi-HfFoo4d061A-unsplash.jpg)
Dataframes & JSON with Java on Jupyter
Simple examples of how to download and import JSON data using Tablesaw, Google Colab, and a few relevant and handy libraries.
November 2021
![Terraform an Athena Database on Google Colab](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642277866873-AY92JMQSZBZIUIUWVPN1/pantheon_temple_at_athens_patrick-EvMearrxas4-unsplash.jpg)
Terraform an Athena Database on Google Colab
Using Google Colab, Terraform & the AWS CLI to setup a database using S3, Glue & Athena.
![Apache Spark with Java on Jupyter](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1641943955640-0I4SI40DJ2OY1ZAIZ65Y/1_CHXBmrc7u_lHFYfLDMwn9g.png)
Apache Spark with Java on Jupyter
A quick start to running Apache Spark on Google Colab using Java
![Terraform, AWS & Google Colab: Getting Started](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/1642010551121-ZWXCEBJDAA1EJ96YI9Q6/0_P255iJS5kX_X6-_I.jpg)
Terraform, AWS & Google Colab: Getting Started
Exercise in creating a simple resource (S3 Bucket) in AWS for data storage using Terraform and the AWS Command Line Interface (CLI) from within a hosted Google Colab (Jupyter) Notebook.
December 2021
![](https://images.squarespace-cdn.com/content/v1/61de098e6a25031a34d6a366/c71c68e3-f42d-45c7-9973-3786de7740bc/1_1e4gUeoBkOEjEKMWuNLWtA.png)
Reading RData Files with Java on Google Colab
Using the Java Kernel in a Jupyter Notebook environment (Google Colab) to read RData files (an R programming language data file format)
Subscribe to my newsletter.
Sign up with your email address to receive news and updates.