Creating a single boxplot from multiple dataframes

Question

I have three dataframes containing only one column, 'Time', and differing numbers of rows of pandas datetime values. Ex:

      Time
0  3 days    
1  16 days   
2  6 days     
3  4 days     
4  4 days     
5  4 days

I would like to create a single box plot (candlestick) that has three bars representing the distribution of the times in all dataframes side by side. How do I go about accomplishing this?

Mr_Z · Accepted Answer · 2018-10-20 20:44:33Z

6

You could accomplish this by adding a column to each dataframe which holds an information to group the single values. Here is a small example:

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

I have generated only some random int values.

time1 = pd.DataFrame(np.random.randint(1,30,10), columns=['Time'] )
time2 = pd.DataFrame(np.random.randint(1,30,10), columns=['Time'] )
time3 = pd.DataFrame(np.random.randint(1,30,10), columns=['Time'] )

Instead of int values you can also use the pands Timedelta. But you need to get the days value.

time1 = pd.DataFrame([pd.Timedelta(days=random.randint(0,30)).days for x in range(10)], columns=['Time'] )
time2 = pd.DataFrame([pd.Timedelta(days=random.randint(0,30)).days for x in range(10)], columns=['Time'] )
time3 = pd.DataFrame([pd.Timedelta(days=random.randint(0,30)).days for x in range(10)], columns=['Time'] )

Then I added the column "Data" to each dataframe with a unique identifier.

time1["Data"] = "A"
time2["Data"] = "B"
time3["Data"] = "C"

Now I concatenate all dataframe.

times = [time1, time2, time3]
allTimes = pd.concat(times)

With the method boxplot you can group now the data by the column "Data"

plt.figure()
allTimes.boxplot(by="Data")

This results in following image:

edited Oct 20, 2018 at 20:44

answered Oct 18, 2018 at 8:40

Mr_Z

5391 gold badge5 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cjmaria Over a year ago

Your time columns in the example contain integers, mine contain date time objects, and plotting in this way didn't work with date times.

Mr_Z Over a year ago

I'v edited my example so that you can see how it works with datetime. You need to call the days value of your objects.

Collectives™ on Stack Overflow

Creating a single boxplot from multiple dataframes

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related