Pandas: Can i predict how many hours my employees are going to work next year based on how many days and hours they worked this year? [closed]

Question

i'm planning to predict 2023 working hours and days for my employees , each employee have DaysCount= number of days he worked , also HoursWorked= hours he spent in work . The question is ,it's possible ? can i predict next year's stats based on these 2 values ? any ideas ?

Answer 1

Yes, you can, but maybe, It's will be a imprecise solution. But, I'll try to help you to find a solution.

• Number of attributes: first of all, a machine learning model requires good features about the person historic to make predictions about their future, use only two attributes could be not the sufficiente to do accurate predictions.

• Size of training: another important aspect is the training size, for example, do you have a long historic for all employees? For example, do you have the individual historic, for each employee, for their last decade?

• Modelling: An important aspect that you should think is about the modelling. How do you want to train the model? For example, do you will use the january's employee historic to predict the february? Or, do you will use the 2021 employee's historic to predict 2022, and use this model to predict 2023? Do you have any others features to feed the model? What explain the number of days and hours worked? For example, the hours worked could be explained by the day week, this means that, if you work in a restaurant (for example), you can work more in the weekends. So, it's important to model know the week day. The days count could be afect by the vacations/hollydays, so, include these informations in the data should be very important. After that, you must consider how you will split the data into training and test. Do you will use the historic of the last seven-days to predict the next one day? Or, you will use the last month historic to predict the next month?