Re: [Tutor] pandas read sql query advice

On Apr 28, 2018 06:54, Glenn Schultz wrote: > > All, > > I have the following set-up (below) which will be used to call data from > multiple sectors. There is a sql query (transact sql) and connection. This > works fine. However, I would like to parametrize the query

[Tutor] pandas read sql query advice

All, I have the following set-up (below) which will be used to call data from multiple sectors.  There is a sql query (transact sql) and connection.  This works fine.  However, I would like to parametrize the query so I can enter different sectors.  I have checked through pyodbc and several

[Tutor] [Pandas] - Creating a bigger dataframe by using one minor dataframe as variable of another minor dataframe

I’m working with two dataframes obtained from the infrared spectroscopy analysis (yes, we’re scientists trying to work better using python). The dataframes are as follows: ***DATA1:*** IRRAMAN CM-1 245.54 730.41 3538.10 s1 100 3.93 204.17 3237.13 s6 93

[Tutor] pandas

Dear tutor, python3 pandas The function below returns the maximum cost row of the df. def maximum(): return [df.loc[df['cost'].idxmax()]] maximum() But I am only interested in specific column of the df. How could I extract from the returned row of the df? Thanks in advance.

Re: [Tutor] pandas data frame

 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

Re: [Tutor] pandas data frame

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

Re: [Tutor] pandas data frame

Bachir Bachir via Tutor wrote: > 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

[Tutor] pandas data frame

 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

Re: [Tutor] pandas data frame

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

Re: [Tutor] pandas data frame

On 17/01/16 11:43, Bachir Bachir via Tutor wrote: > i am new in python and pandas thanks muchBachir Hi Bachir, This list is for questions about core Python and its standard library. Although pandas is part of some Python distributions (eg anaconda) it's not really part of the standard library