Re organize rows by one column's name using pandas

Question

I have a dataframe, column 1 contains the name of the states. Column 2 contains the city. Column 3, 4, 5...contains data I'm interested in for each city. Right now, the order of rows is random. I'd like to group the rows so that cities that are in the same states are grouped together.

For example, After the ordering, data will look like this:

Pennsylvania, Bryn Mawr, 33, 283, 392
Pennsylvania, Philadelphia, 37, 373, 328
Pennsylvania, Pittsburgh, 37, 483, 479

Ohio, Columbus, 382, 830, 281
Ohio, Hudson, 291, 39, 10

Before ordering the rows are in random order. Any idea would be appreciated!

Does this answer your question? [how to sort pandas dataframe from one column](https://stackoverflow.com/questions/37787698/how-to-sort-pandas-dataframe-from-one-column) — Heikura, Jul 28 '20 at 10:11

score 2 · Answer 1 · answered Jul 28 '20 at 10:10

2

You should try df.sort_values(by=['your column name'])

Here find full documentation of sort_values method : https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.sort_values.html

answered Jul 28 '20 at 10:10

Vincent

46
1

Cyril FRANCOIS · Accepted Answer · 2020-07-28T10:12:30.077

1

You can use sort_values :

df = df.sort_values(by =['State'] )

edited Jul 28 '20 at 10:12

answered Jul 28 '20 at 10:09

Cyril FRANCOIS

88
8

Re organize rows by one column's name using pandas

2 Answers2