Formatting output of series in python pandas

Question

Here is my DataFrame. This is a representation of an 8-hour day, and the many different combinations of schedules. The time is in 24hr time. Input:

solutions = problem.getSolutions()
pd.options.display.max_columns = None
df = pd.DataFrame(solutions)

Output:

   WorkHr1 WorkHr2 WorkHr3 WorkHr4  WorkOut  Lunch   FreeHour  Cleaning
0       13     14     15     16        11     10         9        12
1       13     14     15     16        11     10        12         9
2       13     14     15     16        11     12        10         9
3       13     14     15     16        11     12         9        10
4       13     14     15     16        12     11        10         9
..     ...    ...    ...    ...       ...    ...       ...       ...

I can create a series using:

series1 = pd.Series(solutions[0])
print(series1)

And I get this output:

WorkHr1     13
WorkHr2     14
WorkHr3     15
WorkHr4     16
WorkOut     11
Lunch       10
FreeHour     9
Cleaning    12

How can I switch the columns of this series so that the time is first?

Also, is there any possible way to display the rows in order of time? Like this:

  9    FreeHour
 10       Lunch
 11     WorkOut
 12    Cleaning
 13     WorkHr1
 14     WorkHr2
 15     WorkHr3
 16     WorkHr4

user7864386 · Accepted Answer · 2022-02-23 03:20:14Z

2

You can reverse it by passing its index as data and data as index to a Series constructor:

out = pd.Series(s.index, index=s).sort_index()

Output:

9     FreeHour
10       Lunch
11     WorkOut
12    Cleaning
13     WorkHr1
14     WorkHr2
15     WorkHr3
16     WorkHr4
dtype: object

answered Feb 23, 2022 at 3:20

user7864386

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Formatting output of series in python pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related