Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import numpy as np
- from scipy.interpolate import interp1d
- # set up a sample dataframe
- df = pd.DataFrame(np.random.uniform(0,1,(11)), columns=['a'])
- # sort it by the desired series and caculate the percentile
- sdf = df.sort_values('a').reset_index()
- sdf['b'] = sdf.index / float(len(sdf) - 1)
- # setup the interpolator using the value as the index
- interp = interp1d(sdf['a'], sdf['b'])
- vals = df['a'].quantile(0.57)
- print(interp(vals))
- print(interp(df['a'].quantile(0.43)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement