replacing values with .loc

Question

I am trying to loop through a DF column and get just the URL key from a column of strings. I have printed every stage of this loop and it works correctly. However when printing the DF after the loop I only see the column I create with the correct values and the loop has now replaced other values in those rows a NaN. what am i doing wrong here? #clean playlists link for just key and create new column 'key'

for i, value in enumerate(tats['Playlist Link'].values):
    splitstring = str(value).split('/')
    value = splitstring[len(splitstring)-1]
    if "?" in value:
        value = value[0:value.index('?')]
    else:
        value = value
    tats.loc[i, 'key'] = value

you may want to fix the indentation after the for loop

Franco Piccolo
– Franco Piccolo

2021-03-01 16:21:15 +00:00
Commented Mar 1, 2021 at 16:21 — Franco Piccolo
– Franco Piccolo, Commented Mar 1, 2021 at 16:21
please elaborate for a noob like myself

Kyle Shaffer
– Kyle Shaffer

2021-03-01 16:39:25 +00:00
Commented Mar 1, 2021 at 16:39 — Kyle Shaffer
– Kyle Shaffer, Commented Mar 1, 2021 at 16:39

Franco Piccolo · Accepted Answer · 2021-03-01 16:44:19Z

0

Try:

for i, value in zip(tats.index, tats['Playlist Link'].values):
    ...

answered Mar 1, 2021 at 16:44

Franco Piccolo

7,4909 gold badges42 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kyle Shaffer Over a year ago

i like your style, friend. works like a charm

Franco Piccolo Over a year ago

Welcome my bro.

Collectives™ on Stack Overflow

replacing values with .loc

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related