Community Profile

# Namrata Goswami

Last seen: presque 2 ans il y a Actif depuis 2020

#### Content Feed

Afficher par

Question

How to distribute a value X over Y periods to make it follow a normal distribution ?
How to distribute a value X over Y periods to make it follow a normal distribution ? Example: I have a value 16.77% and want t...

presque 2 ans il y a | 1 réponse | 0

### 0

réponse

Question

How to fill missing dates (NaT) with the next date ?
My table looks like : ID Amount Date 12 100 Jan-2020 12 400 NaT 12 100 NaT ...

presque 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

Cumulative sum within group, reset when encounters a 0
I have a table and I want to get the cumulative sum within a group(by ID), but the cumulative count should reset if the counter ...

presque 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

How to use fillmissing function within a group ?
I have a table where multiple columns have NaN and I want the NaN to be replaced by the previous valid value in the column, wit...

presque 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

Extract one row per group based on column value from table.
I have a table with multiple rows per ID. I want to extract one row per ID where the date is max/latest. input table: ID ...

presque 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

Create new column in table based on another column value
I have a table with the list of User IDs and I used "Groupummary" to determine the number of occurences of each ID. My table T: ...

environ 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

How to merge two excel files based on common column ?
I have two excel sheets that I need to combine into one. For example File1: ID Name 1 abc 2 ...

environ 2 ans il y a | 1 réponse | 0

### 1

réponse

Question

How to Group data points and add serial numbers within the group ?
I have a table with ID and Date columns. I want to group the data by ID and add serial numbers in a new column call Serial No. a...

environ 2 ans il y a | 2 réponses | 0

réponses