data = """Index CIDADE ESTADO REGIAO CAPITAL POPULACAO_TOTAL_2010
0 Brejo De Areia MA Centro-Oeste 0 5577.0
1 Cujubim RO Centro-Oeste 0 15854.0
2 Balbinos SP Sudeste 0 3702.0
3 Pacaraima RR Centro-Oeste 0 10433.0
4 Araquari SC Centro-Oeste 0 24810.0
5 Pedra Branca Do Amapari AP Centro-Oeste 0 10772.0
6 Ipiranga Do Norte MT Centro-Oeste 0 5123.0
7 Parari PB Centro-Oeste 0 1256.0
8 Colniza MT Centro-Oeste 0 26381.0
9 Luís Eduardo Magalhães BA Centro-Oeste 0 60105.0"""
data = [ i.split ( "\t " ) for i in data.split ( "\n " ) ] # Transformar em Array de Array
import pandas as pd
df = pd.DataFrame ( data[ 1 :] , columns= data[ 0 ] ) # CARREGAR DADOS
del df[ "Index" ] # DELETAR coluna Index
del df[ 'REGIAO' ] # DELETAR coluna REGIAO
regiao = {
"Norte" :[ 'AM' , 'PA' , 'RR' , 'AC' , 'RO' , 'AP' , 'TO' ] ,
"Sul" :[ 'PR' , 'SC' , 'RS' ] ,
"Centro Oeste" :[ 'MT' , 'MS' , 'GO' , 'DF' ] ,
"Nordeste" :[ 'BA' , 'CE' , 'MA' , 'PB' , 'PE' , 'RN' , 'SE' , 'AL' , 'PI' ] ,
"Sudeste" :[ 'SP' , 'RJ' , 'MG' , 'ES' ] ,
}
for k in regiao:
df.loc [ df[ 'ESTADO' ] .isin ( regiao[ k] ) , 'REGIAO' ] = k
print ( df)
ZGF0YSA9ICIiIkluZGV4CUNJREFERQlFU1RBRE8JUkVHSUFPCUNBUElUQUwJUE9QVUxBQ0FPX1RPVEFMXzIwMTAKMAlCcmVqbyBEZSBBcmVpYQlNQQlDZW50cm8tT2VzdGUJMAk1NTc3LjAKMQlDdWp1YmltCVJPCUNlbnRyby1PZXN0ZQkwCTE1ODU0LjAKMglCYWxiaW5vcwlTUAlTdWRlc3RlCTAJMzcwMi4wCjMJUGFjYXJhaW1hCVJSCUNlbnRyby1PZXN0ZQkwCTEwNDMzLjAKNAlBcmFxdWFyaQlTQwlDZW50cm8tT2VzdGUJMAkyNDgxMC4wCjUJUGVkcmEgQnJhbmNhIERvIEFtYXBhcmkJQVAJQ2VudHJvLU9lc3RlCTAJMTA3NzIuMAo2CUlwaXJhbmdhIERvIE5vcnRlCU1UCUNlbnRyby1PZXN0ZQkwCTUxMjMuMAo3CVBhcmFyaQlQQglDZW50cm8tT2VzdGUJMAkxMjU2LjAKOAlDb2xuaXphCU1UCUNlbnRyby1PZXN0ZQkwCTI2MzgxLjAKOQlMdcOtcyBFZHVhcmRvIE1hZ2FsaMOjZXMJQkEJQ2VudHJvLU9lc3RlCTAJNjAxMDUuMCIiIgoKZGF0YSA9IFsgaS5zcGxpdCgiXHQiKSBmb3IgaSBpbiBkYXRhLnNwbGl0KCJcbiIpIF0gIyBUcmFuc2Zvcm1hciBlbSBBcnJheSBkZSBBcnJheQoKCmltcG9ydCBwYW5kYXMgYXMgcGQKCmRmID0gcGQuRGF0YUZyYW1lKCBkYXRhWzE6XSwgY29sdW1ucz1kYXRhWzBdICkgIyBDQVJSRUdBUiBEQURPUwoKZGVsIGRmWyJJbmRleCJdICAjIERFTEVUQVIgY29sdW5hIEluZGV4CmRlbCBkZlsnUkVHSUFPJ10gIyBERUxFVEFSIGNvbHVuYSBSRUdJQU8KCgpyZWdpYW8gPSB7CgkiTm9ydGUiOlsnQU0nLCAnUEEnLCAnUlInLCAnQUMnLCdSTycsJ0FQJywgJ1RPJ10sCgkiU3VsIjpbJ1BSJywgJ1NDJywgJ1JTJ10sCgkiQ2VudHJvIE9lc3RlIjpbJ01UJywgJ01TJywgJ0dPJywgJ0RGJ10sCgkiTm9yZGVzdGUiOlsnQkEnLCAnQ0UnLCdNQScsICdQQicsICdQRScsICdSTicsICdTRScsICdBTCcsICdQSSddLAoJIlN1ZGVzdGUiOlsnU1AnLCAnUkonLCAnTUcnLCdFUyddLAp9CgoKZm9yIGsgaW4gcmVnaWFvOgoJZGYubG9jWyBkZlsnRVNUQURPJ10uaXNpbihyZWdpYW9ba10pLCAnUkVHSUFPJ10gPSBrCgpwcmludChkZik=