How to replace several values of a column using lists in python

Question

I have a dataframe name "detalhe" with several columns and one is named: "Concelho". I have a list of unique values of "Concelho" named "Concelho ADENE" and I would like to replace each occurrence with a different list called "INE".

    Concelho ADENE  INE
0   ABRANTES    Abrantes
1   AGUEDA  Águeda
2   AGUIAR DA BEIRA Aguiar da Beira
3   ALANDROAL   Alandroal
4   ALBERGARIA-A-VELHA  Albergaria-a-Velha
... ... ...
284 VIMIOSO Vimioso
285 VINHAIS Vinhais

Both lists have the same length and each entrance correspond (they are alphanumeric sorted) (I also have a csv file with both lists as 2 parallels columns.)

I tried:

detalhe= pd.read_csv('Detalhe.csv')
detalhe['Concelho'].replace(Concelho ADENE,INE)
detalhe

AttributeError: 'Series' object has no attribute '_replace_columnwise'

Ave799 · Accepted Answer · 2021-04-16 12:52:31Z

1

could you please provide a sample code(like below) to check to reproduce the scenario? replacing using list is working fine

df = pd.DataFrame({'A': [0, 1, 2, 3, 4],
                   'B': [5, 6, 7, 8, 9],
                   'C': ['a', 'b', 'c', 'd', 'e']})                  
print(df)
print("-----------")

init = [7,6,9]
final = [17,16,19]
df.B.replace(init,final,inplace=True)
print(df)

output:

A  B  C
0  0  5  a
1  1  6  b
2  2  7  c
3  3  8  d
4  4  9  e
-----------
A   B  C
0  0   5  a
1  1  16  b
2  2  17  c
3  3   8  d
4  4  19  e

answered Apr 16, 2021 at 12:52

Ave799

1877 bronze badges

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

1 Comment

Ricardo Gomes Over a year ago

My error was just not using Inplace=True... TY!!

Collectives™ on Stack Overflow

How to replace several values of a column using lists in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related