Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: pandas column percentile
Post: RE: pandas column percentile
(Aug-04-2022, 02:25 PM)jefsummers Wrote: Pandas quantile returns a dataframe or series. So, dataP >= dataQ is comparing two dataframes. You need to find the value that is the breakpoint and compa...
 nuncio Data Science 7 2,476 Aug-10-2022, 04:41 AM
    Thread: pandas column percentile
Post: RE: pandas column percentile
(Jul-24-2022, 12:41 PM)jefsummers Wrote: I hate dates. Ok that off my chest - I would create new columns based on the timestamp for year, month, and date, make those integers. Would then use groupby...
 nuncio Data Science 7 2,476 Aug-04-2022, 10:52 AM
    Thread: pandas column percentile
Post: RE: pandas column percentile
(Jul-22-2022, 10:08 AM)Larz60+ Wrote: Please show your code, so we know what you're working with. data = pd.read_csv('timeseries_data.csv',parse_dates={'Timestamp':[2]},index_col='Timestamp',dayfirs...
 nuncio Data Science 7 2,476 Jul-22-2022, 10:54 AM
    Thread: pandas column percentile
Post: pandas column percentile
Dear All, I have a time series in a dataframe that contain vaues for each day for many years. How can I compute the average of values above a certain percentile for, say, each month. Thank you
 nuncio Data Science 7 2,476 Jul-22-2022, 06:29 AM
    Thread: read write
Post: read write
def some_condition(line): return "ddd" in line with open('testin.csv') as infile: for line in infile: if some_condition(line): donotline=line else: f =...
 nuncio General Coding Help 2 2,024 Apr-18-2019, 09:10 PM
    Thread: matplotlib annotate datapoints with corresponding dates
Post: matplotlib annotate datapoints with corresponding ...
I am trying to make an MJO phase diagram as this http://www.bom.gov.au/climate/mjo/graphi...40days.gif, in this, we can see the dates annotated against each data point along lines representing a month...
 nuncio General Coding Help 0 1,569 Feb-08-2019, 11:26 AM
    Thread: comparing two columns two different files in pandas
Post: comparing two columns two different files in panda...
The thred subject seems to oversimplify my query. I have a data set something like below h t hu 1 3 5 2 4 5 3 10 3 4 2 5 5 10 6 7 9 3 8 10 3 9 11 2 10 11 1 1 3 5 2 4 5 3 10 3 4 2 5 5 10 6 6 1 2 7 9 3 ...
 nuncio Data Science 0 2,411 Jun-06-2018, 01:04 PM
    Thread: loops in python
Post: loops in python
This seems to be rather simple, but I am not getting there.  I am trying to execute the math for Fourier transform.  Here is the code I wrote import numpy as np x=[1,2,3,4] # my data values fn=np.ara...
 nuncio Data Science 2 3,546 Sep-20-2017, 12:00 PM
    Thread: Python Pandas datetime
Post: RE: Python Pandas datetime
(Jan-06-2017, 04:48 PM)ichabod801 Wrote: datetime.fromtimestamp takes as a parameter the number of seconds since the epoch. That's not what you have, you have the digits of the various parts of the ...
 nuncio Data Science 3 10,215 Jan-08-2017, 09:34 AM
    Thread: Python Pandas datetime
Post: Python Pandas datetime
I have some data which I read in pandas like this data = pd.read_table('filename.txt', sep='  ',index_col=None,engine='python')The first column is date time in the format 120631135243(YYMMDDhhmmss). I...
 nuncio Data Science 3 10,215 Jan-06-2017, 05:14 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020