Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Dean McGrath
Merging Pandas DataFrames in Python
By Dean McGrath, Aspiring Data Analyst Photo by MILKOVÍ on Unsplash Introduction As Data Scientist, we will often find that we are required to analyse data from multiple data sources at the one time. To be successful at achieving this, we need to be able to merge different data sources using a variety of methods efficiently. Today we are going to look at using Pandas built-in .merge() function to join two data sources using several different join methods.
How to Drop Duplicates in Pandas
Learn how to drop duplicates from a Pandas DataFrame to improve your data quality Photo by Samantha Lam on Unsplash Dropping duplicates from your data sets is a task you will regularly have to do as a Data Analyst. Whilst in some cases, duplicates may be valid frequently, they have been created through lax data integrity or incorrect joining methods during data extraction.
How to Combine Python, Pandas & XlsxWriter
Learn how to output a Pandas DataFrame to Excel with formatting using XlsxWriter Photo by Safar Safarov on Unsplash Being able to extract data from a database and output it to Excel is a crucial skill to have as a Data Analyst. Today we are going to look at using a Python package called XlsxWriter to output a small DataFrame to Excel. XlsxWriter is a powerful package that you can use to auto-format Excel worksheets, change the styling and insert objects such as tables.
blp2020: "king of the night", by dj blackpower
supported by 105 fans who also own “blp2020: "king of the night"” this album came out the day after my high school graduation, and there have been tons of memories associated with this one. mike's showing his range on this one - from downright despondent on scarred lungs 1/2 and suffocate to hopeful on stargazer and PLANET to flexing his muscles on take crowns, summer 17 and my favorite, its like basketball. harrisonjohn28 go to album
Data Cleaning Using Python Pandas
A comprehensive guide to using built-in Pandas functions to clean data prior to analysis Photo by Stan Y on Unsplash Over time companies produce and collect a massive amount of data, depending on the company this can come in many different forms such as user-generated content, job applicant data, blog posts, sensor data and payroll transactions.
Python Pandas Iterating a DataFrame
Learn the different ways that you can iterate a Pandas DataFrame using Python Photo by Maicol Santos on Unsplash At times as a Data Scientist, we are going to encounter poor quality data. To be successful we need to be able to effectively manage data quality issues before any analysis. Thankfully there are several powerful open-source libraries that we can utilise to efficiently process data such as Pandas.
Pandas Apply for Power Users
Become a power user by learning Pandas built-in apply() function Photo by Todd Trapani on Unsplash At some point in our data science career, we are going to come across poor quality data, whether it be partially completed records or incorrectly formatted attributes. Being able to manage poor quality data has become a crucial skill as a successful data scientist. Thankfully, there are numerous libraries that have been developed such as Pandas that we can use to efficiently manipulate datasets.
Learning Pandas Profiling
A comprehensive guide to getting started with Pandas Profiling using Python Photo by Sid Balachandran on Unsplash Being a data scientist in today's age is an incredibly exciting and rewarding career. With the explosion of technology and the immense amount of data and content created daily, data scientist continually need to be learning new ways of efficiently analysing this data. One of the most crucial parts of any new data project is the exploratory data analysis phase.
I wake up in the morning and I cry, by Baptist Goth
This work was composed for Dylan Kerr's funeral in June 2020. Dylan is dead and what's left of them now takes the form of Baptist Goth. A fusion of an emo trap idol and a Catholic saint, born out of a time of darkness in Poznan, Poland. tw:suicide Dylan came close to taking their own life, but Baptist Goth saved whatever parts of Dylan were still living and became a new entity. Polish hate speech laws protect religious statues, but not living, queer people.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Dean
Contact Dean, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack