Hi!!
I have to calculate the number of flights operating each day,Now days of operation are mentioned in a single column as 01234567(Its a text)- which means that flight operates on all days except Monday.
I have break this data so, I add 7 more columns for each day from Monday to Sunday and put 1 as value in each column except that for monday.This in the end gives me in total how many flights are operating on each day of the week throughout the schedule.Now the data i have is hugh and i have to do this exercise for all the flights,Can there be any other way of doing it?
I have to calculate the number of flights operating each day,Now days of operation are mentioned in a single column as 01234567(Its a text)- which means that flight operates on all days except Monday.
I have break this data so, I add 7 more columns for each day from Monday to Sunday and put 1 as value in each column except that for monday.This in the end gives me in total how many flights are operating on each day of the week throughout the schedule.Now the data i have is hugh and i have to do this exercise for all the flights,Can there be any other way of doing it?