Want to remove the text from a particular column in excel

[eddywinch82]

Hi shantanu97,

The following, is an alternative simpler method than Larz60+'s, it worked for me :-

import pandas as pd
import re

data = pd.read_csv("magnetic_declination_australia_1.csv") 
#print(data.head())
#data['Magnetic Declination'] = data['Magnetic Declination'].apply(lambda x: x.replace(r"magneticFields\nD ", ""))
data['Magnetic Declination'] = data['Magnetic Declination'].str.replace('magneticFields\nD', '')
#print(data.head())
data

Best Regards

Eddie Winch