Cash Barnes

I am using this page as a place to store and document any valuable work or capstone projects I have completed.

Linked In	https://www.linkedin.com/in/cashbarnes/
Git Hub	https://github.com/CashBarnes
Email	cbarnes@ultranauts.co
Slack	Cash Barnes

Sample Amazon Scraper

This is a sample scraper I wrote as a capstone for Business Track/Codeless Automation path. I took the idea from the scraper I wrote for a client project and wrote a practical example of a scraper for anyone learning selenium to easily follow along or edit as needed for other projects.

You can find the wiki page containing this project here. You can also see it on it's GitHub repository.

Webdriver Error Fix

When completing the Python learning path and beginning to learn Selenium, there was an issue I encountered with having the webdriver in the correct location. Looking back at it, it was a simple issue that I should've easily been able to avoid but still ended up spending a little bit of time trying to figure out why it wasn't working. The issue was that I didn't have the webdriver in the same folder as the Python script I was running (or I just didn't have my webdriver.Chrome() pointing to where I actually had it). This is a quick video I made to help anyone having an error about their webdriver not being found.

Useful SQL Queries for Big Query

I created a wiki page with a few useful SQL queries to get started with searching through Big Query for future data profiling projects. There are also explainations of each query as well as screenshots to help guide anyone through writing them. You can find the wiki page here.

https://ultra.guide/bin/view/Automation/UsefulSQLQueriesByCashBarnes

Displaying Data from a JSON file in R and R Markdown

https://ultra.guide/bin/view/Automation/JSONinRandRMarkdown

Introduction to Cypress and Applitools

https://ultra.guide/bin/view/Automation/IntroductionToCypressAndApplitools

https://github.com/CashBarnes/Intro-Cypress-Test

Data Cleaning Python Steps Used

One of the deliverables for Goldman Sachs is to observe the data they have provided and determine how often specific data is being accessed so they may limit the access of PII (Personal Identifiable Information) data. We were given a list of relevant databases they were concerned about and a list of the fields containing PII. You can find a Git Hub repository containing all Python scripts used in the steps contained in this internal Confluence page here. Any information specific to the client has been left out and all scripts can be modified for future projects

-- CashBarnes - 22 Jan 2022