# pivot()

*noun*

say it: **“PIV-ut”** **/ˈpɪvət/**

A pandas method that reshapes a long table into a wide one, turning one column's values into column headers.

## What does **pivot()** do in pandas?

**pivot()** is a pandas method that turns a long table into a wide one: `index` names the rows, `columns` the column
headers and `values` what fills the cells. If two rows would fill the same cell, it stops with an error instead of
combining them; combining is `pivot_table()`'s job.

```python
import pandas as pd
long = pd.DataFrame({"student_id": [101, 101, 102], "quiz": ["quiz1", "quiz2", "quiz1"], "score": [88, 90, 92]})
print(long.pivot(index="student_id", columns="quiz", values="score"))
# quiz        quiz1  quiz2
# student_id
# 101          88.0   90.0
# 102          92.0    NaN
```

## In a sentence

- “**pivot()** stopped with an error because one student had two scores for the same quiz.”
- “**pivot()** turned the long scores back into one row per student and a column per quiz.”

Level: Freelancer · [More Python terms at this level](https://www.ask-codey.com/glossary?category=python&level=4)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/pivot-python
