In this tutorial, you’ll learn how to display pandas DataFrames horizontally in your Jupyter Notebooks. I find this useful when presenting data to an audience or when delivering tutorials like this one.
Let’s begin by reading in three different DataFrames, assigning them to variable names. By default, nothing is displayed in the output when an assignment statement is the last line of a notebook cell.
import pandas as pd
bikes = pd.read_csv('bikes.csv',...I’m excited to announce the launch of Build an Interactive Data Analytics Dashboard with Python, a comprehensive course that teaches you every step to launch your very own dashboards with Python.
Specifically, you will be building a Coronavirus Forecasting Dashboard (available at https://coronavirus-project.dunderdata.com/) that shows historical and predicted values for deaths and cases for all countries in the world and US states from the ongoing coronavirus pandemic. The final...
The Seaborn data visualization library in Python provides a simple and intuitive interface for making beautiful plots directly from a Pandas DataFrame. When users arrange their data in tidy form, the Seaborn plotting functions perform the heavy lifting by grouping, splitting, aggregating, and plotting data, often with a single line of code. In this article, I will provide my top five reasons for using the Seaborn library to create data visualizations with Python.
I have a new tutorial where I show interesting, unusual and just plain awesome ways to use the pandas library to solve data problems. Pandas is such a versatile library with so many ways to solve so many different problems.
The Advent of Code is a series of 25 fun problems released every December 1st, each containing some kind of data that require some sort of computing power to solve. While pandas is probably not the goto choice for these challenges, it is absolutely has the ability to solve...
In 2014, I was first introduced to pandas and had no idea how to use it. By 2017, I had written the 500 page book Pandas Cookbook. This is roughly the path I took to mastering pandas for free:
The...
If you've worked with the matplotlib data visualization library before, then you'll be familiar with the term figsize, which is measured in figure inches. In a Jupyter Notebook, these default to 6 inches in width by 4 inches in height. But, if you actually measured the physical screen inches on your monitor, you're likely to get different numbers. This post details why this mismatch exists and how to change the settings of your plot so that the matplotlib figure inches match the physical...
If you’ve used matplotlib and seaborn to create data visualizations enough, then you’ve probably run into the issue of overlapping text labels on the x-axis.
Let’s take a look at an example that uses Airbnb listings data.
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
cols = ['neighborhood', 'accommodates', 'price']
airbnb = pd.read_csv('data/airbnb.csv', usecols=cols)
airbnb.head() 
After setting the theme, we create a bar plot of the mean price...
The solutions to the five Dunder Data Pandas Challenges will be presented below. Try these challenges for yourself at python.dunderdata.com before looking at the solutions. Video solutions for all of the challenges are available on YouTube. The following two datasets are used for the challenges.
import pandas as pd
emp = pd.read_csv('../data/employee.csv', parse_dates=['hire_date'])
emp.head(3) 
movie = pd.read_csv('../data/movie.csv', index_col='title')
movie.head(3) 
The solutions to the five Dunder Data Python Challenges will be presented below. Try these challenges for yourself at python.dunderdata.com before looking at the solutions. Video solutions for all of the challenges are available on YouTube.
Given a list of integers. Return the difference between the largest and smallest values.
def exercise_1(a_list):
"""
Parameters
----------
a_list : a list of integers
Returns
-------
an integer
"""
# YOUR CODE HERE
...I’m excited to announce Dunder Data Python and Pandas Challenges! One Python and one Pandas challenge will be released each weekday on python.dunderdata.com. They will vary in difficulty and cover a wide range of topics.
Video solutions for the Python Challenges will be available here with the Pandas Challenges available here. You’ll answer the challenges within your very own Jupyter...
Become an expert at using pandas to do data analysis with the comprehensive book Master Data Analysis with Python containing 500+ exercises and projects.
Recent Posts
Upon registration, you'll get access to the following free courses: