Community Profile

photo

Namrata Goswami


Last seen: 11 mois ago Active since 2020

Statistics

  • Thankful Level 1

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

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

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

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

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

12 mois 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

2

answers