What is data modeling, how is it used, and how can you practice it?

Photo by Tobias Fischer on Unsplash


A Tutorial using window functions to simplify your SQL solutions

(Photo by Ben Stern on Unsplash)


A Tutorial on why you would want to use them and their main differences

Photo by Joshua Golde on Unsplash


The best functions to delete, fix, and reformat column values in your data frame.

Photo by JESHOOTS.COM on Unsplash

Rename a column

df.rename(columns={'RegionName': 'zipcode'}, inplace=True)

Remove rows where the column’s value is null

airbnb_df = airbnb_df.dropna(subset=['zipcode'])


Photo by You X Ventures on Unsplash


Understanding and practicing joins, aggregate functions, and subqueries are the key to your success in a coding interview

Photo by Crew on Unsplash

Joins


Part 3 — How to write a Python script to automate creation of AWS snapshots

orange, blue, pink, green, and brown gears on a black background
orange, blue, pink, green, and brown gears on a black background


Part 2 — How to write a Python script to automate AWS health checks


Part 1 — How to write a Python script to automate adding AWS instance tags

pink, orange, blue, and purple gears on black background
pink, orange, blue, and purple gears on black background


Madison Schott

Just a young female millennial navigating the tech world at Capital One as a software engineer with a non-traditional tech background. @madisonmaeorg on Twitter

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store