Apr-22-2019, 04:23 PM
This seems to work, not sure if it the best way though
import pandas as pd data = pd.read_csv("some_data.csv") data.Result_Notes = data.Result_Notes.astype(str) data.Result_Header = data.Result_Header.astype(str) for index, series in data.iterrows(): desired_number = series['Number_Header'] data.at[index, 'Result_Header'] = desired_number data.at[index, 'Result_Notes'] = 'This is your desired number' print(data) data.to_csv("some_data_output.csv")
Output: Account_Number Invoice_Date Invoice_Number Payor Ground_Tracking_ID_Prefix ... Status Reason Exception Result_Header Result_Notes
0 X1231Z1123 4/13/2019 0000A031 P/P NaN ... XX-XXX NaN NaN 1Z112091091208143 This is your desired number
1 X1231Z1123 4/13/2019 0000A031 P/P NaN ... XX-XXX NaN NaN 1Z112091091208144 This is your desired number
2 X1231Z1123 4/13/2019 0000A031 P/P NaN ... XX-XXX NaN NaN 1Z112091091208145 This is your desired number
3 X1231Z1123 4/13/2019 0000A031 P/P NaN ... XX-XXX NaN NaN 1Z112091091208146 This is your desired number