[PYTHON] Memorandum (conceptual design and program division)
** You can automate it with python, right? Nice to meet you, so I'll do my best Record Part 4 **
2020/9/25 revised The content has changed to something completely different. A problem occurs and I have a headache. For the time being, write the changed specifications again
** ～～ Write only the conclusion first ～～ ** There is nothing in particular on the python implementation
** ～～ I don't care diary ～～ ** Most of the files I make are in non-list format and I have a headache.
For the time being, it seems that they will cooperate if they put together to the point that "If you have such input data, you can automate it like this" ... Is it true ... It's a lie ...
I couldn't help it, so I decided to summarize the design specifications for the time being.
** ～～ Diary up to here ～～ **
The following is a summary of what to do.
We will work in order from ①.
(1) For the raw data in Fig. 1, apply the process of "integrating the working hours if the values other than the employee name and working hours are the same" (the employee name is unnecessary data, so omit it).
(2) Add setting 1 / setting 2 to each row using the comparison table in Table 1.
(3) Calculate the total time for each setting 1 and output it in calendar format as shown in Table 2.
Also, use the most frequent country name for each date as a headline.
(4) Calculate the total time for each setting 2 from the data for one month, and generate the graph and table as shown in Fig. 3.
Figure 1 Original data
Fig. 3 Graph and table
Figure 1 Original data
Fig. 3 Graph and table