Gallery of Projects


jpotter.xyz

This site! Created using Observable Framework for static site generation and data integration via data loaders.

My Website


My Local Weather Dashboard

This dashboard visualizes weather data for Black Mountain, NC. The project uses the National Weather Service api and Observable Framework, CI/CD deployment using GitHub actions.

My Weather


Data Pipeline

This project automates the process of ingesting CSV files, creating a PostgreSQL database, analyzing data structure using llm's, and generating SQL transformations for data cleaning and normalization.

Data Pipeline


Voter Demographics with R

In this project we explore and clean Buncombe County, NC voter data, using R scripts, with visualizations created by ggplot.

Voter Data


Bluesky LLM Posting Bot

An automated Bluesky posting bot written in Python that is configured to generate image descriptions via OpenAI's api, which is then sent to a HuggingFace api endpoint to create an image from the description. The script will then format the data for Bluesky's api and upload to the specific account.

Bluesky LLM Posting


Stellar Classification

This project demonstrates the effectiveness of machine learning in automating stellar classification between giant and dwarf stars. The integration of a PostgreSQL database enhances data accessibility and management. Future work may include refining the model with additional features, exploring other classification algorithms, and expanding the dataset to include more diverse stellar types.

Stellar Classification