Pandas

• Set max row for dataframe output
• Combine df with concat
• Create histogram from df

Set max row for dataframe output

# max row to display dataframe set to 7
import pandas as pd
pd.set_option('display.max_rows', 7)

 

Combine df with concat

# Combine all dataframe with concat
frame_format = [df_f0_f1, df_f1_f2, df_f2_f3, df_f3_f4, df_f4_f5]
df_all = pd.concat(frame_format, sort = False)

 

Create histogram from df

df_trace_person_count sample:

	trace id	no of unique person
0	TRACE_PERSON_0000000003	16
1	TRACE_PERSON_0000000005	20
2	TRACE_PERSON_0000000011	5
...	...	...
313	TRACE_PERSON_0000000995	20
314	TRACE_PERSON_0000000998	6
315	TRACE_PERSON_0000000999	8

Code:

import matplotlib.pyplot as plt

fig = plt.figure(figsize=(10,10)) 
axes1 = fig.add_subplot(1,1,1)
axes1.hist(df_trace_person_count['no of unique person'],bins=72, color='black')
axes1.set_xlabel('Count of people')
axes1.set_ylabel('Count of clusters')

Result: