The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Two Problems in the Absenteeism_data.csv & Absenteeism_new_data.csv

Two Problems in the Absenteeism_data.csv & Absenteeism_new_data.csv

Super Learner
0
Votes
1
Answer

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 Answer

Super Learner
0
Votes

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 …………

×
Online Data Science Training
SAVE 60%