Question from pandas of resample from quantile function

user_16724620 0
Viewed 41
import pandas as pd
new = pd.read_csv(r'C:\Users\cctsa\PycharmProjects\pythonProject\stock_2409.csv')
new['time'] = pd.to_datetime(new['time'])
new.set_index(new['time'], inplace=True)
print(new)
rule_type = '10T'
period_n = new[['ticket']].resample(rule=rule_type).quantile(0.75)

About question from pandas combine "quantile" function, it only show one result from this method, could python have a quick coding to show the result together of quantile(0.25, 0.5, 0.75) at same time? Thanks give me a help.

quantile pandas python
1 Answers

IIUC use if need processing numeric column close:

print (new['close'].dtype)

period_n = new['close'].resample(rule=rule_type).quantile([0.25, 0.5, 0.75])

Or if need procesing close column per tickets:

period_n = new.groupby('ticket')['close'].resample(rule=rule_type).quantile([0.25, 0.5, 0.75])
user_29010020
Related