To calculate average and unique number from a text file using pandas python

Asked Aug 12 '22 at 03:58

Active Aug 12 '22 at 04:24

Viewed 19 times

#To calculate average and unique value from a text file using pandas python.

I am having a text file which is having two columns separated by "," and it is not having any column header. Column[0] has the taxi number and column[1] is having the number of km it had driven.

I want to calculate each taxi's how much km driven, how many times, and the average km driven by a taxi.

For example 00005 has driven 49 km, 3 times and the average is 16.33

I tried using df.groupby(df.columns[0])[df.columns[-1]].sum() - this is giving only sum and df.groupby(df.columns[0])[df.columns[-1]].mean - it is giving mean value but not average

Can someone please guide

edited Aug 12 '22 at 04:24

asked Aug 12 '22 at 03:58

deepak

Use `df.groupby(df.columns[0])[df.columns[-1]].agg(['sum', 'mean', 'count'])` – mozway Aug 12 '22 at 04:01
Thanks @mozway but for mean I am getting different value then average. – deepak Aug 12 '22 at 04:25
(arithmetic) mean and average are the same thing (unless you want to use an different mean? geometric? harmonic?) – mozway Aug 12 '22 at 04:28
Hi, @mozway is it possible to convert this code in the MapReduce program? Because of the huge data, I am thinking to use MapReduce. – deepak Aug 12 '22 at 04:44
I don't know, a wild guess for this kind of questions would be "yes" (I don't know the MapReduce program) – mozway Aug 12 '22 at 04:45
@mozway how to calculate this without using any library like "pandas". – deepak Aug 13 '22 at 07:47
why without libraries? is this an assignment? – mozway Aug 13 '22 at 07:51
Yes, this is an assignment. – deepak Aug 13 '22 at 07:58
1

Then you must provide your own, faithful, attempt. Otherwise this is asking us to do your homework for you ;) – mozway Aug 13 '22 at 09:53

To calculate average and unique number from a text file using pandas python

0 Answers0