- JSON (from website) → use JavaScript / Google Apps Script to connect to API; pull data, and write to Google Sheets
(useful for if you need the data pulled and written automatically every day, without the use of a server or computer that is always on at that time)
- unstructured data from website → write JavaScript or Python code to parse/process → (if analysing) plot using Python libraries
(this is also good for websites without a public API)
- SQL data (on BigQuery) → pull using Python code connecting to BigQuery API → plot using Python libraries
- SQL data (on more local database) → pull using Python code connecting to server → plot using Python libraries
(this is a quick and easy method for data below a certain size)
Advent of SQL 2024 - Topics covered: JSON, CASE, joins, UNION, CTEs, ASCII, string aggregation, array functions, set operations, LAG(), ROUND(), window functions. (PostgreSQL)
Solutions to SQL Puzzles from the Internet - Specifically HackerRank. (SQL Server)
Marketplace Analysis - (unstructured data) This analyses the frequency of each company advertising on a given marketplace by taking the HTML file as an input, since there was no API for this section of the marketplace. (Python, Matplotlib...)
Data Analysis (BigQuery and Python) - This connects to BigQuery's API; runs SQL queries (that I wrote) and plots them using Python libraries.
More Data Analysis - This is going to be a dashboard project, but right now it's a sandbox (Python - connects to API; gets data; uses Pandas, MatPlotLib and NumPy).
A Programme Which Runs and Plots SQL Queries for Inputted Date Ranges - I was so proud of this until I realised how redundant it was. Basically if you need to run an SQL query for a range of dates and plot the results, all you need to do is input a few things as arguments, and it handles all that for you. Just like... many existing programmes already do. Oh well!
Text Analysis (this is not serious) - Some light data analysis using Python (including NumPy and Matplotlib), created on a day when I couldn't think of a project idea that wasn't a joke.
Word Cloud from WhatsApp Data - This is... let's call it social commentary. It's a word cloud and some other stuff using Python and some of its libraries (Pandas, NumPy, Matplotlib, etc.).
Git Guide - A guide to Git that I wrote because of being in multiple environments where all Git-related queries, some with only the most tenuous link, were directed to me.
Previous Advent of Code Attempts: 2020 (Java, JavaScript, Python, Ruby and C#), 2021 (JavaScript) and 2022 - But every year I stop around Christmas Day (but so does everyone else I know). (Python)
Randomised Task Chooser Website - A web page I made that randomly chooses your next task, in case you can't decide (made using JavaScript, HTML and CSS, of course).
Merge Sort Project - A merge sort project that I completed in Java.
Java Sudoku Checker - This takes a sudoku board as a two-dimensional array and tells you if it is complete/correct.
JavaScript Sudoku Checker - The same sudoku checker in JavaScript. I wrote it first (in the language that I knew better), and then knowing that the logic worked, I was able to rewrite it in another language (Java, above), just focusing on the syntax. This is my way of picking up new languages quickly.
Multiplying Numbers as Strings - Multiplies numbers as strings (in JavaScript) to avoid conversion to scientific notation.
Just an Old Solution to a Puzzle - This takes a number and returns the next biggest number that uses the same digits. I may have gone too far back... The code might be terrible. But it works! (JavaScript.)
Random Headline Generator - This (using HTML, CSS and JavaScript) is a parody of racist, fearmongering newspapers. It generates headlines randomly, just like they do.