You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by patcharee <Pa...@uni.no> on 2016/09/07 08:59:00 UTC

Spark DataFrame Plotting

Hi,

I have a dataframe with this schema A:Double, B:Double. How can I plot 
this dataframe as two lines (comparing A and B at each step)?

Best,

Patcharee


Re: Spark DataFrame Plotting

Posted by patcharee <Pa...@uni.no>.
Hi Moon,

When I generate an extra column (schema will be Index:Int, A:Double, 
B:Double), what sql command to generate a graph with 2 lines (Index as a 
X-axis, BOTH A and B as Y-axis)? Do I need to group by?

Thanks!

Patcharee


On 07. sep. 2016 16:58, moon soo Lee wrote:
> You will need to generate extra column which can be used as a X-axis 
> for column A and B.
>
> On Wed, Sep 7, 2016 at 2:34 AM Abhisar Mohapatra 
> <abhisar.mohapatra@inmobi.com <ma...@inmobi.com>> 
> wrote:
>
>     I am not sure ,But can you try once by grouby function in
>     zeppelin.If uou can group by columns then i guess that would do
>     the trick or pass the data to another HTML block and use d3
>     comparison chart to plot it
>
>     On Wed, Sep 7, 2016 at 2:56 PM, patcharee
>     <Patcharee.Thongtra@uni.no <ma...@uni.no>> wrote:
>
>         Normal select * gives me one column on X-axis and another on
>         Y-axis. I cannot make both A:Double, B:Double displayed on
>         Y-axis. How to do that?
>
>         Patcharee
>
>
>         On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
>>         You can do a normal select * on the dataframe and it would be
>>         automatically interpreted.
>>
>>         On Wed, Sep 7, 2016 at 2:29 PM, patcharee
>>         <Patcharee.Thongtra@uni.no
>>         <ma...@uni.no>> wrote:
>>
>>             Hi,
>>
>>             I have a dataframe with this schema A:Double, B:Double.
>>             How can I plot this dataframe as two lines (comparing A
>>             and B at each step)?
>>
>>             Best,
>>
>>             Patcharee
>>
>>
>>
>>         _____________________________________________________________
>>         The information contained in this communication is intended
>>         solely for the use of the individual or entity to whom it is
>>         addressed and others authorized to receive it. It may contain
>>         confidential or legally privileged information. If you are
>>         not the intended recipient you are hereby notified that any
>>         disclosure, copying, distribution or taking any action in
>>         reliance on the contents of this information is strictly
>>         prohibited and may be unlawful. If you have received this
>>         communication in error, please notify us immediately by
>>         responding to this email and then delete it from your system.
>>         The firm is neither liable for the proper and complete
>>         transmission of the information contained in this
>>         communication nor for any delay in its receipt. 
>
>
>
>     _____________________________________________________________
>     The information contained in this communication is intended solely
>     for the use of the individual or entity to whom it is addressed
>     and others authorized to receive it. It may contain confidential
>     or legally privileged information. If you are not the intended
>     recipient you are hereby notified that any disclosure, copying,
>     distribution or taking any action in reliance on the contents of
>     this information is strictly prohibited and may be unlawful. If
>     you have received this communication in error, please notify us
>     immediately by responding to this email and then delete it from
>     your system. The firm is neither liable for the proper and
>     complete transmission of the information contained in this
>     communication nor for any delay in its receipt.
>


Re: Spark DataFrame Plotting

Posted by moon soo Lee <mo...@apache.org>.
You will need to generate extra column which can be used as a X-axis for
column A and B.

On Wed, Sep 7, 2016 at 2:34 AM Abhisar Mohapatra <
abhisar.mohapatra@inmobi.com> wrote:

> I am not sure ,But can you try once by grouby function in zeppelin.If uou
> can group by columns then i guess that would do the trick or pass the data
> to another HTML block and use d3 comparison chart to plot it
>
> On Wed, Sep 7, 2016 at 2:56 PM, patcharee <Pa...@uni.no>
> wrote:
>
>> Normal select * gives me one column on X-axis and another on Y-axis. I
>> cannot make both A:Double, B:Double displayed on Y-axis. How to do that?
>>
>> Patcharee
>>
>> On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
>>
>> You can do a normal select * on the dataframe and it would be
>> automatically interpreted.
>>
>> On Wed, Sep 7, 2016 at 2:29 PM, patcharee <Pa...@uni.no>
>> wrote:
>>
>>> Hi,
>>>
>>> I have a dataframe with this schema A:Double, B:Double. How can I plot
>>> this dataframe as two lines (comparing A and B at each step)?
>>>
>>> Best,
>>>
>>> Patcharee
>>>
>>>
>>
>> _____________________________________________________________
>> The information contained in this communication is intended solely for
>> the use of the individual or entity to whom it is addressed and others
>> authorized to receive it. It may contain confidential or legally privileged
>> information. If you are not the intended recipient you are hereby notified
>> that any disclosure, copying, distribution or taking any action in reliance
>> on the contents of this information is strictly prohibited and may be
>> unlawful. If you have received this communication in error, please notify
>> us immediately by responding to this email and then delete it from your
>> system. The firm is neither liable for the proper and complete transmission
>> of the information contained in this communication nor for any delay in its
>> receipt.
>>
>>
>>
>
> _____________________________________________________________
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.

Re: Spark DataFrame Plotting

Posted by Abhisar Mohapatra <ab...@inmobi.com>.
I am not sure ,But can you try once by grouby function in zeppelin.If uou
can group by columns then i guess that would do the trick or pass the data
to another HTML block and use d3 comparison chart to plot it

On Wed, Sep 7, 2016 at 2:56 PM, patcharee <Pa...@uni.no> wrote:

> Normal select * gives me one column on X-axis and another on Y-axis. I
> cannot make both A:Double, B:Double displayed on Y-axis. How to do that?
>
> Patcharee
>
> On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
>
> You can do a normal select * on the dataframe and it would be
> automatically interpreted.
>
> On Wed, Sep 7, 2016 at 2:29 PM, patcharee <Pa...@uni.no>
> wrote:
>
>> Hi,
>>
>> I have a dataframe with this schema A:Double, B:Double. How can I plot
>> this dataframe as two lines (comparing A and B at each step)?
>>
>> Best,
>>
>> Patcharee
>>
>>
>
> _____________________________________________________________
> The information contained in this communication is intended solely for the
> use of the individual or entity to whom it is addressed and others
> authorized to receive it. It may contain confidential or legally privileged
> information. If you are not the intended recipient you are hereby notified
> that any disclosure, copying, distribution or taking any action in reliance
> on the contents of this information is strictly prohibited and may be
> unlawful. If you have received this communication in error, please notify
> us immediately by responding to this email and then delete it from your
> system. The firm is neither liable for the proper and complete transmission
> of the information contained in this communication nor for any delay in its
> receipt.
>
>
>

-- 
_____________________________________________________________
The information contained in this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally privileged 
information. If you are not the intended recipient you are hereby notified 
that any disclosure, copying, distribution or taking any action in reliance 
on the contents of this information is strictly prohibited and may be 
unlawful. If you have received this communication in error, please notify 
us immediately by responding to this email and then delete it from your 
system. The firm is neither liable for the proper and complete transmission 
of the information contained in this communication nor for any delay in its 
receipt.

Re: Spark DataFrame Plotting

Posted by patcharee <Pa...@uni.no>.
Normal select * gives me one column on X-axis and another on Y-axis. I 
cannot make both A:Double, B:Double displayed on Y-axis. How to do that?

Patcharee


On 07. sep. 2016 11:05, Abhisar Mohapatra wrote:
> You can do a normal select * on the dataframe and it would be 
> automatically interpreted.
>
> On Wed, Sep 7, 2016 at 2:29 PM, patcharee <Patcharee.Thongtra@uni.no 
> <ma...@uni.no>> wrote:
>
>     Hi,
>
>     I have a dataframe with this schema A:Double, B:Double. How can I
>     plot this dataframe as two lines (comparing A and B at each step)?
>
>     Best,
>
>     Patcharee
>
>
>
> _____________________________________________________________
> The information contained in this communication is intended solely for 
> the use of the individual or entity to whom it is addressed and others 
> authorized to receive it. It may contain confidential or legally 
> privileged information. If you are not the intended recipient you are 
> hereby notified that any disclosure, copying, distribution or taking 
> any action in reliance on the contents of this information is strictly 
> prohibited and may be unlawful. If you have received this 
> communication in error, please notify us immediately by responding to 
> this email and then delete it from your system. The firm is neither 
> liable for the proper and complete transmission of the information 
> contained in this communication nor for any delay in its receipt. 


Re: Spark DataFrame Plotting

Posted by Abhisar Mohapatra <ab...@inmobi.com>.
You can do a normal select * on the dataframe and it would be automatically
interpreted.

On Wed, Sep 7, 2016 at 2:29 PM, patcharee <Pa...@uni.no> wrote:

> Hi,
>
> I have a dataframe with this schema A:Double, B:Double. How can I plot
> this dataframe as two lines (comparing A and B at each step)?
>
> Best,
>
> Patcharee
>
>

-- 
_____________________________________________________________
The information contained in this communication is intended solely for the 
use of the individual or entity to whom it is addressed and others 
authorized to receive it. It may contain confidential or legally privileged 
information. If you are not the intended recipient you are hereby notified 
that any disclosure, copying, distribution or taking any action in reliance 
on the contents of this information is strictly prohibited and may be 
unlawful. If you have received this communication in error, please notify 
us immediately by responding to this email and then delete it from your 
system. The firm is neither liable for the proper and complete transmission 
of the information contained in this communication nor for any delay in its 
receipt.