I have created a df one column of which contains string values that I want to trim based on a different int value each time. Ex.: From:
| length | String |
|---|---|
| -3 | adcdef |
| -5 | ghijkl |
I wanna get:
| length | String |
|---|---|
| -3 | def |
| -5 | hijkl |
What I tried is the following:
for i in range(len(df.index)):
val = df['string'].iloc[i]
n = df['length'].iloc[i]
df['string'].iloc[i] = val[n:]
However, I keep getting this warning:
SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame
Any ideas on how I can avoid getting it?
Thanks!
Advertisement
Answer
Try with apply:
df["String"] = df.apply(lambda x: x["String"][x["lenght"]:], axis=1) >>> df lenght String 0 -3 def 1 -5 hijkl