How to iterate through date header of excel sheet using pandas in python?

Question

I have an excel sheet how can i iterate through the date as i want to iterate to each row. but there are two headers. i have attached a pic below. one headers is of date. and another header is some timing in , out time, total hours, etc. so each date has 7 columns. so there are 30 days. i want to store the date some where in a variable as i can know which month is this. and then i want to read the value in the header of each date. and do some functionality. I am using python and panda library

_____________|____________|        7/16/19                    |        8/16/19                     |        9/16/19                     |        10/16/19                   |        11/16/19                    | ....
Employee Name|Employee ID |in-time|out-time|total-hours|status||in-time|out-time|total-hours|status||in-time|out-time|total-hours|status|in-time|out-time|total-hours|status||in-time|out-time|total-hours|status|
Shrey        | SHAA       | 5:00  | 13:00  |8        | WO   | ..................................................................................
asd   | dh  |  ...................................................................................
asf   | ge  |  ....................................................................................
asdfd   | ew  |  ...................................................................................
afdsfds   | er  |  ......................................................................................```

Do anyone know how can i check which date is this as it is in header. and according to date i have to iterate — python_nerd
– python_nerd, Commented Jul 17, 2019 at 9:17

Carp-Bezverhnii Maxim · Accepted Answer · 2019-07-16 12:40:43Z

0

Did you try to find on google how to do this? You will find a lot of examples! Also you can look here: Python Loop through Excel sheets, place into one df

answered Jul 16, 2019 at 12:40

Carp-Bezverhnii Maxim

711 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

python_nerd Over a year ago

How can i loop through according to date because there are two headers. It's not a excel sheet it's data only

Carp-Bezverhnii Maxim Over a year ago

"I have an excel sheet how can i iterate through the date as i want to iterate to each row." this is what I readed!

Carp-Bezverhnii Maxim Over a year ago

and first: find out what type of date this is.

python_nerd Over a year ago

Sorry in excel this type of data is the example you are showing tell about changing the sheets. as i don't want to work on different sheets as i only have one sheet and there is a data in it which look like the above way i have added. as this date contains 6 block of in time, out time, etc. so i just want to get specific data of specific date. can you tell how ?

Collectives™ on Stack Overflow

How to iterate through date header of excel sheet using pandas in python?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related