Question: A python code that can read an excel spread sheet of days a user can work, and writes an excel spread sheet of a schedule

A python code that can read an excel spread sheet of days a user can work, and writes an excel spread sheet of a schedule for a week.

^general idea of input/output

\begin{tabular}{|l|l|l|l|l|l|l|} \hline 1 & Name & Monday & Tuesday & Wednesday & Thursday & Friday \\ \hline 2 & Name1 & Y & Y & Y & Y & Y \\ \hline 3 & Name2 & N & N & Y & N & Y \\ \hline 4 & & & & & \\ \hline 5 & & & & & \\ \hline 6 & & & & & \\ \hline 7 & & & & \\ \hline 8 & & & & & \\ \hline \end{tabular} Expected output Name1,... Name1,... Name1,Name2, Name1, ... Name1, Name 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

python code that can read an excel spread sheet of days a user can work, and writes a seperate excel spread sheet of a schedule for a week

I just need answer for the practical part to cross-check my figures. Pls ignore the reporting part in the requirement. I can take care of that. Client Scenario: Andrea Danielson P. O. Box 38#6...

Henry and Sophia have reached out for help with financial planning. Despite earning a substantial income and enjoying a comfortable lifestyle, they are concerned about their financial situation...

Take ScreenShot on the Social Security for Stanley and Ellen using this link https://www.socialsecurity.gov/planners/retire/AnypiaApplet.html Finn 3272 Life Insurance and Professional Financial...

Hello, Can you help me to finish step 5 to step 10, and also make a cash flow statement at the end? Here I attach the instruction file and the excel file that you continue to work on. There were some...

ELE VATE t h e three disciplines o f advanced strate g i c th i nk ing R I C H H O R WAT H NEW YORK Times Be s ts ellin g A u thor O n s trateg y Contents Introduction 1 Elevate\t1 Importance of...

Overview of the case. What do you think of the particular assignment given to Browning? TEXTBOOK : Brown, C.V., DeHayes, D.W., Hoffer, J.A., Martin, E.W., and Perkins, W.C. Managing Information...

pls help solve it all Pre-Assessment Checklist: Task 3 - Project The purpose of this checklist The pre-assessment checklist helps students determine if they are ready for assessment. The...

Synthesys Informatics is a medium sized company that develops and manufactures mobile data collection devices. You are an employee of Synthesys and work as project manager in the product development...

Question 2 The budgeted and standard data for productivity include the following Direct labour Ten employees work for 45 hour a week. The standard rate of pay is ksh 4 per hour. Output per hour is 40...

Barbara age 64 retired in June Starting in July Cinthia received 2 000 per month from annuity she has contributed 260 000 to annuity her live expectancy is 20 years. How much is excluded from income...

A detachable warrant is a warrant that can be detached and traded separately from the bond weth which is was asoed. Most traded warrants arte orignully artached to bonds or preferred stocks. a . Frue...

solve the problem Lee Verly will be opening his company called LV Catering in January of the next year. He predicts that January, February and March will generate $195,000, $110,000 and $130,000...

LO3 Distinguish between mandated and voluntary benefits and list three examples of each.

LO2 Analyze the differences between employee benefits in the United States and those in other countries.

3. A reduction in the use of commissions for salespeople has occurred because more sales are taking place online with limited interaction with salespeople. This has changed the nature of pay given to...