#The following is the steps used to analyze the data and create the tidy_dataset
For creating the project first needs to download the required datset. This can be done using R to the repository or manually downloading and copy to the working directory Reading the datasets into R and do the necessary codes to do the following things
Merges the training and the test sets to create one data set. Extracts only the measurements on the mean and standard deviation for each measurement. Uses descriptive activity names to name the activities in the data set Appropriately labels the data set with descriptive variable names. From the data set in step 4, creates a second, independent tidy data set with the average of each variable for each activity and each subject.
#run_analysis.R
creates results folder if it does not exist (all files are stored in this folder)
loads features.txt used for columns
loads X_train.txt, y_train.txt, subject_train.txt
X_train contains the data using the feature data set as columns
y_train contains the activity labels
subject_train contains the ids
loads and appends test dataset using X_test.txt, y_test.txt, subject_test.txt
X_test contains the data using the feature data set as columns
y_test contains the activity labels
subject_test contains the ids
appends train and test data
rearrange the data using id
loads activity_labels.txt
changes the data activity row to use the activity labels
saves the mean and std into mean_and_std.csv
saves the tidy dataset into tidy_dataset.csv
##mean_and_std.csv
variables Present
id activity tBodyAcc.std...X tBodyAcc.std...Y tBodyAcc.std...Z tGravityAcc.std...X tGravityAcc.std...Y tGravityAcc.std...Z tBodyAccJerk.std...X tBodyAccJerk.std...Y tBodyAccJerk.std...Z tBodyGyro.std...X tBodyGyro.std...Y tBodyGyro.std...Z tBodyGyroJerk.std...X tBodyGyroJerk.std...Y tBodyGyroJerk.std...Z tBodyAccMag.std.. tGravityAccMag.std.. tBodyAccJerkMag.std.. tBodyGyroMag.std.. tBodyGyroJerkMag.std.. fBodyAcc.std...X fBodyAcc.std...Y fBodyAcc.std...Z fBodyAccJerk.std...X fBodyAccJerk.std...Y fBodyAccJerk.std...Z fBodyGyro.std...X fBodyGyro.std...Y fBodyGyro.std...Z fBodyAccMag.std.. fBodyBodyAccJerkMag.std.. fBodyBodyGyroMag.std.. fBodyBodyGyroJerkMag.std.. tBodyAcc.mean...X tBodyAcc.mean...Y tBodyAcc.mean...Z tGravityAcc.mean...X tGravityAcc.mean...Y tGravityAcc.mean...Z tBodyAccJerk.mean...X tBodyAccJerk.mean...Y tBodyAccJerk.mean...Z tBodyGyro.mean...X tBodyGyro.mean...Y tBodyGyro.mean...Z tBodyGyroJerk.mean...X tBodyGyroJerk.mean...Y tBodyGyroJerk.mean...Z tBodyAccMag.mean.. tGravityAccMag.mean.. tBodyAccJerkMag.mean.. tBodyGyroMag.mean.. tBodyGyroJerkMag.mean.. fBodyAcc.mean...X fBodyAcc.mean...Y fBodyAcc.mean...Z fBodyAcc.meanFreq...X fBodyAcc.meanFreq...Y fBodyAcc.meanFreq...Z fBodyAccJerk.mean...X fBodyAccJerk.mean...Y fBodyAccJerk.mean...Z fBodyAccJerk.meanFreq...X fBodyAccJerk.meanFreq...Y fBodyAccJerk.meanFreq...Z fBodyGyro.mean...X fBodyGyro.mean...Y fBodyGyro.mean...Z fBodyGyro.meanFreq...X fBodyGyro.meanFreq...Y fBodyGyro.meanFreq...Z fBodyAccMag.mean.. fBodyAccMag.meanFreq.. fBodyBodyAccJerkMag.mean.. fBodyBodyAccJerkMag.meanFreq.. fBodyBodyGyroMag.mean.. fBodyBodyGyroMag.meanFreq.. fBodyBodyGyroJerkMag.mean.. fBodyBodyGyroJerkMag.meanFreq..
##tidy_dataset.csv.csv
variables:
id activity tBodyAcc.std...X_mean tBodyAcc.std...Y_mean tBodyAcc.std...Z_mean tGravityAcc.std...X_mean tGravityAcc.std...Y_mean tGravityAcc.std...Z_mean tBodyAccJerk.std...X_mean tBodyAccJerk.std...Y_mean tBodyAccJerk.std...Z_mean tBodyGyro.std...X_mean tBodyGyro.std...Y_mean tBodyGyro.std...Z_mean tBodyGyroJerk.std...X_mean tBodyGyroJerk.std...Y_mean tBodyGyroJerk.std...Z_mean tBodyAccMag.std.._mean tGravityAccMag.std.._mean tBodyAccJerkMag.std.._mean tBodyGyroMag.std.._mean tBodyGyroJerkMag.std.._mean fBodyAcc.std...X_mean fBodyAcc.std...Y_mean fBodyAcc.std...Z_mean fBodyAccJerk.std...X_mean fBodyAccJerk.std...Y_mean fBodyAccJerk.std...Z_mean fBodyGyro.std...X_mean fBodyGyro.std...Y_mean fBodyGyro.std...Z_mean fBodyAccMag.std.._mean fBodyBodyAccJerkMag.std.._mean fBodyBodyGyroMag.std.._mean fBodyBodyGyroJerkMag.std.._mean tBodyAcc.mean...X_mean tBodyAcc.mean...Y_mean tBodyAcc.mean...Z_mean tGravityAcc.mean...X_mean tGravityAcc.mean...Y_mean tGravityAcc.mean...Z_mean tBodyAccJerk.mean...X_mean tBodyAccJerk.mean...Y_mean tBodyAccJerk.mean...Z_mean tBodyGyro.mean...X_mean tBodyGyro.mean...Y_mean tBodyGyro.mean...Z_mean tBodyGyroJerk.mean...X_mean tBodyGyroJerk.mean...Y_mean tBodyGyroJerk.mean...Z_mean tBodyAccMag.mean.._mean tGravityAccMag.mean.._mean tBodyAccJerkMag.mean.._mean tBodyGyroMag.mean.._mean tBodyGyroJerkMag.mean.._mean fBodyAcc.mean...X_mean fBodyAcc.mean...Y_mean fBodyAcc.mean...Z_mean fBodyAcc.meanFreq...X_mean fBodyAcc.meanFreq...Y_mean fBodyAcc.meanFreq...Z_mean fBodyAccJerk.mean...X_mean fBodyAccJerk.mean...Y_mean fBodyAccJerk.mean...Z_mean fBodyAccJerk.meanFreq...X_mean fBodyAccJerk.meanFreq...Y_mean fBodyAccJerk.meanFreq...Z_mean fBodyGyro.mean...X_mean fBodyGyro.mean...Y_mean fBodyGyro.mean...Z_mean fBodyGyro.meanFreq...X_mean fBodyGyro.meanFreq...Y_mean fBodyGyro.meanFreq...Z_mean fBodyAccMag.mean.._mean fBodyAccMag.meanFreq.._mean fBodyBodyAccJerkMag.mean.._mean fBodyBodyAccJerkMag.meanFreq.._mean fBodyBodyGyroMag.mean.._mean fBodyBodyGyroMag.meanFreq.._mean fBodyBodyGyroJerkMag.mean.._mean fBodyBodyGyroJerkMag.meanFreq.._mean