CODE EXAMPLE FOR PYTHON

update cell in sheet by column name using pandas

  # creating a simple dataframe

df = pd.DataFrame({'name': ['Olivia','Dean','Alex','Jon','Tom','Jane','Kate'],
           'age': [32,23,45,35,20,28,55],
           'sex':['female', 'male','male','male','male','female','female']})