I am trying to add an incrementing number to the end of a string and apply this to every row in one column of my dataframe. The column has 76 rows. Ideally I want the output to look like this:
Event Reference Number
FEBRUARY_2019_1
FEBRUARY_2019_2
FEBRUARY_2019_3
I am trying to use apply with a lambda function but am stuck trying to figure out the next step.
df_Trade_File['Event Reference Number'].apply(lambda x: enumerate(df_Trade_File['Event Reference Number']))
First thing to note is that for the change to take affect you will need to set your df to the result at which time you could use apply or something to format it but in this situation you could probably do something simpler like:
df_Trade_File['Event Reference Number'] = df_Trade_File['Event Reference Number'] + '_' + str(df.index)
assuming you are using a standard index of 1-76.
df.index idea. It makes the line shorter and cleaner assuming generic index ofc
Try using Series.str.cat
df["Event Reference Number"] = df["Event Reference Number"].str.cat(map(str, df.index), sep='_')
If you're using an index other than standard index replace map(str, df.index) with a range but make it all strings or python will yell at you:
map(str, range(1, df.shape[0]+1))
sep keyword?")