[Tutor] pandas data frame
Bachir Bachir
bachir_bac at yahoo.com
Mon Jan 18 05:31:49 EST 2016
Hi Peter Thank you much for your help its very appreciated ,bellow is an example of what i need. The main dataframe ( need to be separated into separate dataframes ). The desired dataframes output correctly as i need it to be,Thanks much
Main dataframendx V_id Average Mean Peak 0 1 3 2 51 2 2 1 62 3 4 1 83 1 2 2 74 2 3 3 65 3 5 3 46 1 1 1 87 2 2 5 108 3 5 5 99 1 2 5 1010 2 5 5 911 3 4 3 10
Dataframe-1ndx V_id Average Mean Peak 0 1 3 2 53 1 2 2 76 1 1 1 89 1 2 5 10
Dataframe-2ndx V_id Averag Mean Peak 1 2 2 1 64 2 3 3 67 2 2 5 1010 2 5 5 9
Dataframe-3ndx V_id Average Mean Peak 2 3 4 1 85 3 5 3 48 3 5 5 911 3 4 3 10
Bachir
On Monday, January 18, 2016 11:25 AM, Peter Otten <__peter__ at web.de> wrote:
Bachir Bachir wrote:
[Bachir, please send your mails to the list, not to me. That way you
increase the likelihood to get a good answer]
>> On Sunday, January 17, 2016 4:20 PM, Peter Otten <__peter__ at web.de>
>> wrote:
>> Bachir Bachir via Tutor wrote:
>>> Hello EverybodyI need to sort a dataframe according to a specific column
>>> the create new dataframes according to the sorted columns each new
>>> created dataframe should contain the list(set('the sorted element)any
>>> help please, i am new in python and pandas thanks muchBachir
>>
>> Like this?
>>
>> >>> df
>>
>> foo bar
>> 0 3.3 b
>> 1 2.2 b
>> 2 7.5 a
>> 3 1.1 c
>> 4 4.7 a
>>
>> [5 rows x 2 columns]
>>
>> >>> df.groupby("bar").sum()
>>
>> foo
>> bar
>> a 12.2
>> b 5.5
>> c 1.1
>>
>> [3 rows x 1 columns]
> Thanks Peter ,This way but i want keep all the table elements only
> separate them by a single column
I'm sorry, I don't understand what you mean by "separate them by a single
column". Can you give an example? What exactly should the sorted version of
>> >>> df
>>
>> foo bar
>> 0 3.3 b
>> 1 2.2 b
>> 2 7.5 a
>> 3 1.1 c
>> 4 4.7 a
>>
>> [5 rows x 2 columns]
look like?
_______________________________________________
Tutor maillist - Tutor at python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
More information about the Tutor
mailing list