groupby with aggregate method in Python

Asked Jul 22 '17 at 18:01

Active Jul 22 '17 at 18:07

Viewed 93 times

count =dataframe[dataframe["Type"]=="h"].sort_values("Date",ascending=False).groupby("Date").count()

mean = dataframe[dataframe["Type"]=="h"].sort_values("Date",ascending=False).groupby("Date").mean()

var = dataframe[dataframe["Type"]=="h"].sort_values("Date", ascending=False).groupby("Date").std()

dataframe is a pandas dataframe. count and mean are working but outputting var shows the following error: InvalidOperation: []

edited Jul 22 '17 at 18:07

ksai

asked Jul 22 '17 at 18:01

Adithya Somanathan

what is the `datatype` of `Date` ? – ksai Jul 22 '17 at 18:03
@ksai datetime64 – Adithya Somanathan Jul 22 '17 at 18:06
Can you find the `std()` of `datetime64` – ksai Jul 22 '17 at 18:06
@ksai It is just grouping by date. std() operator is for the columns of the dataframe which are numeric. – Adithya Somanathan Jul 22 '17 at 18:09
Can you provide the dataframe – ksai Jul 22 '17 at 18:11
https://stackoverflow.com/questions/12589481/python-pandas-multiple-aggregations-of-the-same-column this might be something you're looking for. – i.n.n.m Jul 22 '17 at 18:15
try `yourdf.describe()` function. This might be a good option too! – i.n.n.m Jul 22 '17 at 18:19
Can you try to convert the date into their exact millisecond value and then try to apply those functions !! Beause witb My knowledge i know it only works why numerical values not dates – Espoir Murhabazi Jul 22 '17 at 20:05

groupby with aggregate method in Python

0 Answers0