Pandas DataFrame reindex() Method
Example
Change the row indexes of the DataFrame:
import pandas as pd
data = {
"age": [50, 40, 30, 40],
"qualified": [True, False, False, False]
}
idx = ["Sally", "Mary",
"John", "Monica"]
df = pd.DataFrame(data, index=idx)
newidx =
["Robert", "Cindy", "Chloe", "Pete"]
newdf = df.reindex(newidx)
print(newdf)
Try it Yourself »
Definition and Usage
The reindex() method allows you to change
the row indexes, and the columns labels.
Note: The values are set to NaN if the new index is not the same as the old.
Syntax
dataframe.reindex(keys, method, copy, level, fill_value, limit,
tolerance)
Parameters
The method, copy,
level,
fill_value,
limit,
tolerance parameters are
keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| keys | Required. String or list containing row indexes or column labels | |
| method | None |
Optional, default None. Specifies the method to use when filling holes in the indexes. For increasing/decreasing indexes only. |
| copy | True |
Optional, default True. Whether to return a new object (a copy) when all the new indexes are the same as the old |
| level | Number Label |
Optional |
| fill_value | List of values | Optional, default NaN. Specifies the value to use for missing values |
| limit | Number | Optional, default None. |
| tolerance | Optional |
Return Value
A DataFrame with the result.
This function does NOT make changes to the original DataFrame object.
