Python Panda (Page: 8)
Go to Page:
- Panda Series;
- Pandas DataFrame: Creation;
- Pandas: Create test DataFrame;
- Pandas DataFrame: Add/Remove;
- Pandas DataFrame: Export/Import;
- Panda search and select;
- Pandas Cheat Sheet;
- Pandas: MultiIndex DataFrame;
DataFrame in Pandas can have more that one index column. In this case these DataFrames are called multi-index dataframes. In this short artile, I will show you how to create and use Multi-index DataFrame
Creation MultiIndex DataFrame
We have table with Shape, Color, Count and Size information for some objects stored in CSV data. First of all, we will read CSV this dataset into a dataframe without any indexes.
import pandas as pd
import io
data = io.StringIO('''Shape,Color,Count,Size
Circle,Red,5,1.2
Circle,Green,6,0.9
Circle,Green,6,1.1
Square,Red,15,2.5
Square,Green,3,2.9
Oval,Green,21,0.5
''')
dfu = pd.read_csv(data)
dfu |
| DataFrame without index Our test DataFrame without any indexes |
At the second step, we will declare columns ‘Shape’ and ‘Color’ as index columns
df = dfu.set_index(['Shape', 'Color'])
df |
| DataFrame with two indexes. DataFrame with two columns ‘Shape’ and ‘Color’, declared as an indexes |
Grouping by indexes
Group DataFrame by one index
It is possible to group by any indexes and do some calculations within these groups. For example, lets group all objects by its ‘Shape’ and calculate mean values for the rest of parameters
df.groupby(level=['Shape']).mean() |
| Mean values for ‘Shape’ Calculation of mean values for all groups in ‘Shape’ |
It is possible to group by any indexes. For example let’s count how many data we have for different ‘Color’.
It is important to remember, that count() give number of elements without NaN and size() give total number of elements, with NaN
df.groupby(level=['Color']).count() |
| Count group by ‘Color’ Grouped by ‘Color’ and then counted. Obviously that all columns will have the same values, because there are the same amount of information in every column. |
Group DataFrame by two indexes
It is possible to group by few indexes. And also it is possible to specify an order of grouping. So let’s group by ‘Color’ and then by ‘Shape’ and then let’s calculate the average values in every group.
df.groupby(level=['Color','Shape']).mean() |
| Mean of group by ‘Color’ and ‘Shape’ Grouped by ‘Color’ and then by ‘Shape’ and calculating mean value in every group |
Use group
After grouping, it it is possible to call one group
gb = df.groupby(level=['Color','Shape'])
gb.get_group(('Green', 'Oval')) |
| Using one group After group by it is possible to use one group by specify it’s indexes |
Go to Page: 1; 2; 3; 4; 5; 6; 7; 8;
Published: 2021-11-05 09:11:16
Updated: 2021-12-17 02:48:39
Last 10 artitles
- 2023-12-25 01:48:38 - In-place and out-place Numpy functions
- 2023-12-25 00:58:08 - First order ordinary differential equations
- 2023-12-25 00:22:15 - How to increase swap space in Ubuntu
- 2023-12-24 04:03:12 - How to accelerate math calculations with Numba and Cython
- 2023-12-19 00:38:20 - 3 ways of function caching in Python
- 2023-12-19 00:16:55 - Accelerating Python
- 2023-12-16 12:26:55 - BioPython
- 2023-12-02 11:05:34 - Reading FITS files with astropy
- 2023-12-02 05:23:42 - Astropy
- 2023-12-01 00:33:16 - Circle length calculation with the Monte-Carlo method
9 popular artitles
- Python Panda (3435)
- Python NumPy (2979)
- Python DICTionary HowTo (1591)
- Python LIST HowTo (1469)
- Python (1422)
- Python Generators (1280)
- Python: How to make absolute links in BeautifulSoup (1081)
- Programming language (967)
- NumPy: What the difference between mgrid and meshgrid (940)
