Finding median of entire pandas Data frame

Question

I'm trying to find the median flow of the entire dataframe. The first part of this is to select only certain items in the dataframe.

There were two problems with this, it included parts of the data frame that aren't in 'states'. Also, the median was not a single value, it was based on row. How would I get the overall median of all the data in the dataframe?

Answer 1

Two options:

1) A pandas option:

df.stack().median()

2) A numpy option:

np.median(df.values)