Apr-07-2017, 11:30 AM
(Apr-07-2017, 10:41 AM)yamanda Wrote: For example i am looking for position of cell that is write "GOAL" in sheet?Can use
iloc
or at
to get by position.Eg:
name age weight seniority pay 0 Bob 34 121 13 69000 1 Goal 19 63 2 23300 2 Amy 45 59 5 45000 3 Frank 56 93 12 57000 4 Kaka 23 55 7 45000 5 Udo 27 65 3 39000 6 Vera 31 71 8 45000 7 Betty 22 77 5 45000 >>> work_data.iloc[1, 0] 'Goal' >>> work_data.iloc[1]['name'] 'Goal' >>> work_data.at[1, 'name'] 'Goal'