Python | Pandas.pivot()
pandas.pivot(index, columns, values) function produces pivot table based on 3 columns of the DataFrame. Uses unique values from index / columns and fills with values.
Parameters:
index[ndarray] : Labels to use to make new frame’s index
columns[ndarray] : Labels to use to make new frame’s columns
values[ndarray] : Values to use for populating new frame’s valuesReturns: Reshaped DataFrame
Exception: ValueError raised if there are any duplicates.
Code:
# Create a simple dataframe # importing pandas as pd import pandas as pd # creating a dataframe df = pd.DataFrame({'A': ['John', 'Boby', 'Mina'], 'B': ['Masters', 'Graduate', 'Graduate'], 'C': [27, 23, 21]}) df |
chevron_right
filter_none
# values can be an object or a list df.pivot('A', 'B', 'C') |
chevron_right
filter_none
# value is a list df.pivot(index ='A', columns ='B', values =['C', 'A']) |
chevron_right
filter_none
Raise ValueError when there are any index, columns combinations with multiple values.
# importing pandas as pd import pandas as pd # creating a dataframe df = pd.DataFrame({'A': ['John', 'John', 'Mina'], 'B': ['Masters', 'Masters', 'Graduate'], 'C': [27, 23, 21]}) df.pivot('A', 'B', 'C') |
chevron_right
filter_none
ValueError: Index contains duplicate entries, cannot reshape
Recommended Posts:
- Important differences between Python 2.x and Python 3.x with examples
- Python | Merge Python key values to list
- Reading Python File-Like Objects from C | Python
- Python | Sort Python Dictionaries by Key or Value
- Python | Add Logging to Python Libraries
- Python | Add Logging to a Python Script
- Python | Set 4 (Dictionary, Keywords in Python)
- JavaScript vs Python : Can Python Overtop JavaScript by 2020?
- chr() in Python
- abs() in Python
- bin() in Python
- zip() in Python
- SHA in Python
- max() and min() in Python
- Any & All in Python
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
