Ryan Barker's Projects
Develop an Interactive Dashboard using JavaScript and the Plotly/D3 libraries. Initialize the dashboard with visuals which can be updated when a user changes the Sample ID DropDown menu
Create a tableau story/dashboard showcasing visualizations and insights into the NYC Citi Bike service. Write analysis to support the visuals, and present them in a professional and visually appealing format.
Create a Logistic Regression model to predict the credit risk of customers to a lending company. Use historical data and train the model before making predictions of test data. Lastly write an analysis report on the models created.
Group ETL project. Extract data from supplied Excel files, transform/clean the data using Python Pandas library and export the cleaned data to CSV files. Finally generate an ERD and SQL Schema for a new database to store the extracted data
Use scikit-learn and the KMeans clustering algorithm to analyse a Crypto currency dataset
Generate various plots and statistics to develop analysis on fictional data regarding the testing of new drugs.
Create a neural network through TensorFlow and Keras to build a model which has the ability to assess an organisation's ability to be successful with funding from the Alphabet Soup charity
Using Crowdfunding data, add additional columns, conditional formatting and pivot tables/charts to identify trends and insights into what creates a successful project.
Automatically generate summary GitHub statistics images for your profile using Actions, no server required
Use PySpark and SparkSQL to execute SQL queries through a temporary view of the DataFrame created. Conduct additional queries on cached and partitioned data to determine runtime comparisons.
Using a live Dataset from USGS, create a Leaflet Map Visualization of the Global earthquakes. Markers represent the magnitude and depth at which they occurred
Create a NoSQL database with MongoDB. Import the documents into a new collection, perform update and delete tasks on various records to complete the database. Finally conduct exploratory analysis on the database
Bootcamp: Project 1
Interact with API's to gather current weather conditions for global random cities. Use the gathered Weather data to determine vacation opportunities by identifying the nearest hotel.
Config files for my GitHub profile.
Create ERD, SQL Database and Tables, Import data and create SQL queries to produce specific lists from the data and various tables.
Using the ORM SQLAlchemy, connect to a SQLite database to retrieve data, perform climate analysis and design a Flask API based on the queries developed within the analysis
Create a VBA script which iterates through stock market tickers and delivers a summary for each. Repeat the process for all years (each worksheet) within the same code.
Using the BeautifulSoup module, extract data from a Mars News website and a table containing weather information for Mars. Create Python objects with the data and Pandas DataFrame to analyze and visualize the extracted data