I am not sure if this is correct title. I have let’s say 3000 members, each one is ranked based on number of points. Max rank is 3000, min rank is 1. I need to check for each member on which top 10% is the member (top 10%, top 20%, …, top 90%) based on… Read More How to get percentile in "reverse" in php

I’m looking for a percentile function that accepts an array and an element where it would return closest percentile of the element. Some examples percentile([1,2,3,4,5], 2) => 40% percentile([1,2,3,4,5], 2.5) => 40% percentile([1,2,3,4,5], 6) => 100% Does anything like this or similar exist within python or numpy? Numpy does this np.percentile(a=[1,2,3,4,5], q=3) => 1.12 which… Read More How to compute percentile for an external element with given array?

For example, I have a dataset of 30-years air temperature of a city, the dataset looks like: Year Julian_date temperature 1991 1 2.1 1991 2 2.2 … … … 1991 365 2.3 1992 1 2.1 … … … 1992 365 2.5 … … … 2020 366 2.5 I would like to calculate the 90th percentile… Read More Return the 90th percentile values in R

I’m trying calculate the quintiles within each group of a dataframe. If I do: mtcars %>% group_by(gear,carb) %>% summarise(total = sum(wt), .groups = "keep") %>% mutate(rank = ntile(total,5)) all entries within the rank column are equal to 1. What am I doing wrong here? >Solution : Because when you group_by(gear, carb), unique combinations of these… Read More using ntile within a group

I’m trying to calculate the percentile rank for 2021, relative to the 1981-2021 climatology for June/July/August average temperatures. My data looks like below but much larger: 1981 1982 1983 2021 22 34 40 42 25 36 32 33 For each row, I need to calculate the number of values which are lower or equal to… Read More How to sum values in a row that are less/equal to the last value (for multiple rows)?

I have the following dataset. I want to find the average run of the lower 20 percentile. For example: If I divide the runs column into 5 batches then the first two rows will be in the 20 percentile. So the average run of these two rows will be (1+2)/2 = 1.5 How do I… Read More Calculate the average of the lowest n percentile

I have a dataframe with multiple columns. I want to create boolean column, flagging if the value belongs to 90th percentile and above. My data frame also contains multiple zeros. Example: Name Value Val1 1000 Val2 910 Val3 800 Val4 700 Val5 600 Val6 500 Val7 400 Val8 300 Val9 200 Val10 100 Val11 0… Read More Create a boolean column in pandas datafame based on percentile values of another column