Python Forum
How to reset row value in pandas
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to reset row value in pandas
#1
Hi,
I have below dataframe:

df
ID   Grp subGrp Rank  SNO
A.1  A.0  A     S      1
A.2  A.0  A     S      1
A.2  A.0  A     N      1
A.6  A.0  A     N      1
A.3  A.0  A     S      1 
A.1  A.B  A     3      1
A.2  A.B  A     3      1
A.4  A.0  A     3      1
A.2  A.0  A     3      1
Now I want to increase SNO by 1 in each row, but reset at each repeating ID(at first repeat row) & same columns "subGrp" &"Rank"

Desired output:

ID Grp subGrp Rank SNO
A.1 A.0 A S 1
A.2 A.0 A S 2
A.2 A.0 A S 1
A.6 A.0 A S 2
A.3 A.0 A S 3
A.1 A.0 A S 1
A.2 A.0 A S 2
A.4 A.0 A S 3
A.2 A.0 A S 1
A.1 A.0 A S 2

A.1 rpeats & A.2 repeats but its coninuouse so not reset at A.2. A.2 rpeats again 8th row, reset and increase by one next row.
Reply


Messages In This Thread
How to reset row value in pandas - by Mekala - Sep-19-2020, 09:36 AM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020