python - How to create a new csv file with only modified datas?(Pandas)

Question

I want to create a new csv file with only modified datas. The input csv file is of example as

input.csv

Now I want to create a new csv file of modified datas only like

The condition is :

df1.loc[df1['Code'].astype(str).str.len() >12, 'Code']= '0'

What I've tried is

import pandas as pd

df1 = pd.read_csv('input.csv')
df1.loc[df1['Code'].astype(str).str.len() >12, 'Code']= ''


df2 = df1.reindex(['ID','Name','Code','Changed Code'],axis=1)

How to create a new dataframe for modified datas in this case? Any suggestions or ideas?

question from:https://stackoverflow.com/questions/65661760/how-to-create-a-new-csv-file-with-only-modified-dataspandas

Answer 1

This solved my problem.

import pandas as pd

df1 = pd.read_csv('input.csv')


df2 = df1.loc[df1['Code'].astype(str).str.len() >12]
df2 = df2.reindex(['Id','Name','Code','Changed Code'],axis=1)

df2.loc[df2['Code'].astype(str).str.len() >12,'Changed Code']='0'
df2