Community Profile

# Namrata Goswami

Last seen: environ un an ago Active since 2020

View badges

#### Content Feed

View by

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...

environ un an ago | 0 answers | 0

### 0

answers

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 ...

environ un an ago | 1 answer | 0

### 1

answer

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 ...

environ un an ago | 1 answer | 0

### 1

answer

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...

environ un an ago | 1 answer | 0

### 1

answer

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 ...

environ un an ago | 1 answer | 0

### 1

answer

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 un an ago | 2 answers | 0

### 2

answers

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 un an ago | 1 answer | 0

### 1

answer

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 un an ago | 2 answers | 0

answers