Madison Gipson

Mar 20

Solving the Data Dilemma: Efficiently Load CSV Data into a SQL Database

You’re probably reading this article because you have a similar challenge to the one I had — you need to get data from a spreadsheet into a SQL database. Pick your poison, but Python is a great tool to accomplish this. This article will compare not one but FOUR ways…

Sql

5 min read

Solving the Data Dilemma: Efficiently Load CSV Data into a SQL Database

Published in Towards Dev

·Dec 17, 2021

Connecting to a SQL Server from Linux/Mac OSX with Python and R

This is a tutorial to do exactly what the title indicates — connect to a SQL server from Linux/Mac OSX with Python and R. This is the primary resource I used to get started in Python and this is what I used for R, but while following along I noticed…

Sql

6 min read

Connecting to a SQL Server from Linux/Mac OSX with Python and R

Published in Dev Genius

·Dec 9, 2021

Eliminating Useless Tags from HTML

Quick, easy, and no setup required. Say you have some HTML: <html> <body> <p> This is my body <span> text </span> . </p> <div> <p> Then here's another body <span style="width=300px;"> STYLED </span> </p> </div> </body> </html> Your first question might be: but why? Honestly, I don’t really know, but…

HTML

3 min read

Published in Dev Genius

·May 21, 2021

The Underrated Productivity Hack: Computer Shortcuts

Using keyboard shortcuts is an incredibly underrated productivity hack. Invest a small amount of time in learning them, and you’re guaranteed to increase productivity and streamline workflows. Note: as I discover more useful keyboard , or people contribute their insights in the comments, this list will be updated! I cannot…

Productivity

7 min read

May 18, 2021

In(ternship) Retrospect: what I wish I would’ve known prior to my first internship.

Lessons learned — two years and three internships later. Flashback to March 2019. I’m a computer science newbie, just a year into my degree after switching over from music. After attending a conference for women in STEM hosted at Harvard, I was left with an overhwelming sense of excitement and…

Internships

5 min read

In(ternship) Retrospect: what I wish I would’ve known prior to my first internship.

Published in Python in Plain English

·Mar 29, 2021

Making the Most of Neo4j: Integrating Python Code with Py2Neo

I’d be surprised to come across a programmer or data scientist who hasn’t used Python for at least one project. …

Python

4 min read

Published in The Startup

·Jan 10, 2021

LinkedIn Tips: Reach All-Star Status & Open Opportunity Doors

If you’ve already mastered your LinkedIn and are ready to take it to the next level, check out my article on how to make your website/ePortfolio really stand out. As a twenty-something in the twenty-first century, my professional digital presence is essential in my pursuit of a fulfilling career. Even…

Linked In

11 min read

Published in Analytics Vidhya

·Dec 14, 2020

Automate Neo4j Database Construction with Python

Tutorial detailing how to import data and create your graph database via a Python script. — A recent project of mine has involved creating a massive (upwards of a million nodes and relationships) graph database in Neo4j. When there’s that much to process, having an automated script comes in clutch. This article outlines some tips I have for anyone in a similar situation. Code is linked…

Data Science

4 min read

Automate Neo4j Database Construction with Python

Published in The Startup

·Dec 13, 2020

Running a Cypher Query With Parameters Through a Python Script

I’ve been working on a project for a few months now that has involved tying a Neo4j database to a Dash application, which ultimately comes down to being able to run Cypher queries through Python code. The library Py2Neo has been incredibly useful for this; you can run Cypher queries…

Data Science

2 min read

Running a Cypher Query With Parameters Through a Python Script

Jun 19, 2020

Tips for Creating a Stellar ePortfolio

To start, let’s answer a few questions. What’s an ePortfolio? An ePortfolio is basically a professional, personalized landing page; you can think of it as a customizable LinkedIn. Why should you have an ePortfolio? An ePortfolio is like your LinkedIn on steroids. You can include whatever content you’d like, not limited to the fields LinkedIn provides, and add your…

Resume

7 min read