Jan-18-2022, 02:32 PM
I have a dataframe like:
ID * Period * value-system
1 * 2021-11 * 1010
2 * 2021-11 * 0
3 * 2021-11 * 988
4 * 2021-11 * 1023
5 * 2021-11 * 0
6 * 2021-12 * 0
7 * 2021-12 * 0
etc.
To create the boxplot I need (with sn catplot), I filtered the dataframe by leaving out all the rows with 0 for value-system. The result is shown in the following plot
.
Now, in the plot several periods are missing (2021-05 through 2021-08). These periods are present in the dataframe, but contain only 0-values, so left out by the filter. Now I want to show these 'missing' periods. With periods = df["Period"].unique() I can get all the periods I need, but how can I show these empty periods in the plot?
Hints are appreciated!
ID * Period * value-system
1 * 2021-11 * 1010
2 * 2021-11 * 0
3 * 2021-11 * 988
4 * 2021-11 * 1023
5 * 2021-11 * 0
6 * 2021-12 * 0
7 * 2021-12 * 0
etc.
To create the boxplot I need (with sn catplot), I filtered the dataframe by leaving out all the rows with 0 for value-system. The result is shown in the following plot
Now, in the plot several periods are missing (2021-05 through 2021-08). These periods are present in the dataframe, but contain only 0-values, so left out by the filter. Now I want to show these 'missing' periods. With periods = df["Period"].unique() I can get all the periods I need, but how can I show these empty periods in the plot?
Hints are appreciated!