Last answered:

22 Oct 2020

Posted on:

22 Oct 2020

1

Two Problems in the Absenteeism_data.csv & Absenteeism_new_data.csv

There are two problems in the Absenteeism_data.csv & Absenteeism_new_data.csv as follows: .................................. Problems 1: In the Absenteeism_data.csv there is a field called 'Pets', however in the Absenteeism_new_data.csv it is called 'Pet' without s.
........................ Problem2: Also, there are 12 columns in the Absenteeism_data.csv (ID Reason for Absence Date Transportation Expense Distance to Work Age Daily Work Load Average Body Mass Index Education Children Pets Absenteeism Time in Hours), while in there are 11 columns in the Absenteeism_new_data.csv (ID Reason for Absence Date Transportation Expense Distance to Work Age Daily Work Load Average Body Mass Index Education Children Pets). The column named (Absenteeism Time in Hours) was missing from the new data.

1 answers ( 0 marked as helpful)
Posted on:

22 Oct 2020

1

The solutions that I did and worked: --------------- 1- Make sure all your CSV files have the same exact names and the same exact number of column.... 1---The correct names in both CSV files are (ID, Reason for Absence, Date, Transportation Expense, Distance to Work, Age, Daily Work Load Average, Body Mass Index, Education, Children, Pet, Absenteeism Time in Hours) ........ Make sure the column is named Pet Not Pets...... 2----The correct number of columns must be (12) in both CSV files, if there is any missing column, please add it to be able to run the module......... 3----After, making sure all files CSV files are corrected..... Now run your module (4.15 Absenteeism Exercise - Logistic Regression_with_comments.ipynb) and things will go smooth. ----------------All the best ............

Submit an answer