Skip to content

Replace de Strings

Replace de Strings em DF

Substituimos os caracteres CG por AX na coluna 'ID_CLiente'

python
df3['ID_Cliente'] = df3['ID_Cliente'].str.replace('CG', 'AX')


Visualizando as alterações

python
df3.head()
out:

ID_Pedido Data_Pedido ID_Cliente Segmento Pais Regiao ID_Produto Categoria Nome_Produto Valor_Venda Quantidade Ano
0 CA-2016-152156 2016-11-08 AX-12520 Consumer United States South FUR-BO-10001798 Furniture Bush Somerset Collection Bookcase 261.9600 3.0 2016
1 CA-2016-152156 2016-11-08 AX-12520 Consumer United States South FUR-CH-10000454 Furniture Hon Deluxe Fabric Upholstered Stacking Chairs,... 731.9400 3.0 2016
2 CA-2016-138688 2016-06-12 DV-13045 Corporate United States West OFF-LA-10000240 Office Supplies Self-Adhesive Address Labels for Typewriters b... 14.6200 2.0 2016
3 US-2015-108966 2015-10-11 SO-20335 Consumer United States South FUR-TA-10000577 Furniture Bretford CR4500 Series Slim Rectangular Table 957.5775 5.0 2015
4 US-2015-108966 2015-10-11 SO-20335 Consumer United States South OFF-ST-10000760 Office Supplies Eldon Fold 'N Roll Cart System 22.3680 2.0 2015