Re: Apply ML to grouped dataframe

2016-08-23 Thread Wen Pei Yu
3| [2.0,16.0]| |12462589343|3| [1.0,1.0]| +---+-++ From: ayan guha To: Wen Pei Yu/China/IBM@IBMCN Cc: user , Nirmal Fernando Date: 08/23/2016 05:13 PM Subject: Re: Apply ML to grouped dataframe I would suggest you to construct a toy probl

Re: Apply ML to grouped dataframe

2016-08-23 Thread ayan guha
46 > PM---On Tue, Aug 23, 2016 at 10:56 AM, Wen Pei Yu Fernando ---08/23/2016 01:55:46 PM---On Tue, Aug 23, 2016 at 10:56 AM, Wen > Pei Yu wrote: > We can group a dataframe b > > From: Nirmal Fernando > To: Wen Pei Yu/China/IBM@IBMCN > Cc: User > Date

Re: Apply ML to grouped dataframe

2016-08-22 Thread Wen Pei Yu
01:55 PM Subject:Re: Apply ML to grouped dataframe On Tue, Aug 23, 2016 at 10:56 AM, Wen Pei Yu wrote: We can group a dataframe by one column like df.groupBy(df.col("gender")) On top of this DF, use a filter that would enable you to extract the grouped DF as separated

Re: Apply ML to grouped dataframe

2016-08-22 Thread Nirmal Fernando
> To: Wen Pei Yu/China/IBM@IBMCN > Cc: User > Date: 08/23/2016 01:14 PM > > Subject: Re: Apply ML to grouped dataframe > -- > > > > Hi Wen, > > AFAIK Spark MLlib implements its machine learning algorithms on top of > Spar

Re: Apply ML to grouped dataframe

2016-08-22 Thread Wen Pei Yu
: Nirmal Fernando To: Wen Pei Yu/China/IBM@IBMCN Cc: User Date: 08/23/2016 01:14 PM Subject: Re: Apply ML to grouped dataframe Hi Wen, AFAIK Spark MLlib implements its machine learning algorithms on top of Spark dataframe API. What did you mean by a grouped dataframe? On T

Re: Apply ML to grouped dataframe

2016-08-22 Thread Nirmal Fernando
park.apache.org/docs/latest/ml-guide.html# > announcement-dataframe-bas > > From: Nirmal Fernando > To: Wen Pei Yu/China/IBM@IBMCN > Cc: User > Date: 08/23/2016 10:26 AM > Subject: Re: Apply ML to grouped dataframe > -- > > > >

Re: Apply ML to grouped dataframe

2016-08-22 Thread Wen Pei Yu
Hi Nirmal I didn't get your point. Can you tell me more about how to use MLlib to grouped dataframe? Regards. Wenpei. From: Nirmal Fernando To: Wen Pei Yu/China/IBM@IBMCN Cc: User Date: 08/23/2016 10:26 AM Subject: Re: Apply ML to grouped dataframe You can use

Re: Apply ML to grouped dataframe

2016-08-22 Thread Nirmal Fernando
You can use Spark MLlib http://spark.apache.org/docs/latest/ml-guide.html#announcement-dataframe-based-api-is-primary-api On Tue, Aug 23, 2016 at 7:34 AM, Wen Pei Yu wrote: > Hi > > We have a dataframe, then want group it and apply a ML algorithm or > statistics(say t test) to each one. Is there

Apply ML to grouped dataframe

2016-08-22 Thread Wen Pei Yu
Hi We have a dataframe, then want group it and apply a ML algorithm or statistics(say t test) to each one. Is there any efficient way for this situation? Currently, we transfer to pyspark, use groupbykey and apply numpy function to array. But this wasn't an efficient way, right? Regards. Wenpei