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
out:
df3.head()
| 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 |