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 <__pete...@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 <__pete...@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@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor