This separate RMarkdown file shows the results when running the code reading the files from the C: drive in the computer for Jamaica
I was able to read the txt file in the computer. However the same syntax produced an error message when read from the same file in GitHub, thus making the exercise non-reproducible
BReg_Jam <- read.table("MICS Jamaica BReg without intro paragrap Titles subtitles and with underscore row names.txt", dec = ",")
BReg_Jam## V1 V2 V3 V4 V5 V6 V7
## 1 Total 62.2 20.5 16.4 99.1 1.432 (*)
## 2 Male 59.4 21.3 18.3 99.1 767.000 (*)
## 3 Female 65.4 19.5 14.2 99.0 665.000 (*)
## 4 Urban 61.0 21.5 17.1 99.6 760.000 (*)
## 5 Greater_Kingston_Metropolitan_Area 62.2 21.7 16.1 100.0 441.000 -
## 6 Other_Urban_Centres 59.4 21.2 18.4 99.1 319.000 (*)
## 7 Rural 63.5 19.3 15.7 98.4 672.000 (*)
## 8 0-11 43.7 16.3 37.3 97.4 272.000 (*)
## 9 12-23 56.8 19.4 23.3 99.5 289.000 (*)
## 10 24-35 59.7 25.4 14.0 99.1 283.000 (*)
## 11 36-47 73.3 20.3 5.9 99.5 275.000 (*)
## 12 48-59 75.6 20.8 3.2 99.6 313.000 (*)
## 13 Primary_or_less (67.6) (13.1) (14.0) (94.6) 33.000 (*)
## 14 Lower_secondary 57.2 20.1 22.7 100.0 163.000 -
## 15 Upper_secondary 61.0 20.8 16.9 98.8 799.000 (*)
## 16 Post_secondary_plus 65.6 20.5 13.5 99.6 432.000 (*)
## 17 Special_education (*) (*) (*) (*) 1.000 -
## 18 Missing/DK (*) (*) (*) (*) 3.000 -
## 19 Ha_functional_difficulty (48.4) (30.7) (17.3) (96.4) 34.000 (*)
## 20 Has_no_functional_difficulty 70.6 21.8 7.2 99.5 837.000 (*)
## 21 Black 61.7 20.6 16.7 99.0 1.343 (*)
## 22 Other 69.0 18.4 12.6 100.0 89.000 -
## 23 Church_of_God 62.3 22.6 14.6 99.5 437.000 (*)
## 24 Pentecostal 65.6 17.9 16.0 99.5 172.000 (*)
## 25 Seventh-day_Adventist 55.8 19.2 22.1 97.1 188.000 (*)
## 26 Other_religion/denomination 62.9 20.8 15.7 99.3 422.000 (*)
## 27 No_religion 62.8 18.8 17.4 98.9 207.000 (*)
## 28 Missing/DK (*) (*) (*) (*) 6.000 -
## 29 Poorest 52.1 24.3 20.9 97.3 331.000 (*)
## 30 Second 65.5 20.1 14.4 100.0 355.000 -
## 31 Middle 60.4 19.6 19.0 99.1 288.000 (*)
## 32 Fourth 64.7 19.1 15.4 99.1 251.000 (*)
## 33 Richest 71.8 17.8 10.4 100.0 208.000 -
## V8
## 1 14
## 2 7
## 3 6
## 4 3
## 5 0
## 6 3
## 7 11
## 8 7
## 9 1
## 10 3
## 11 1
## 12 1
## 13 2
## 14 0
## 15 10
## 16 2
## 17 0
## 18 0
## 19 1
## 20 4
## 21 14
## 22 0
## 23 2
## 24 1
## 25 5
## 26 3
## 27 2
## 28 0
## 29 9
## 30 0
## 31 3
## 32 2
## 33 0I was also able to convert back to a CSV file
write.csv(BReg_Jam, "BReg_Jam.csv")
BReg_Jamback<- read.csv("BReg_Jam.csv")
BReg_Jamback## X V1 V2 V3 V4 V5 V6
## 1 1 Total 62.2 20.5 16.4 99.1 1.432
## 2 2 Male 59.4 21.3 18.3 99.1 767.000
## 3 3 Female 65.4 19.5 14.2 99.0 665.000
## 4 4 Urban 61.0 21.5 17.1 99.6 760.000
## 5 5 Greater_Kingston_Metropolitan_Area 62.2 21.7 16.1 100.0 441.000
## 6 6 Other_Urban_Centres 59.4 21.2 18.4 99.1 319.000
## 7 7 Rural 63.5 19.3 15.7 98.4 672.000
## 8 8 0-11 43.7 16.3 37.3 97.4 272.000
## 9 9 12-23 56.8 19.4 23.3 99.5 289.000
## 10 10 24-35 59.7 25.4 14.0 99.1 283.000
## 11 11 36-47 73.3 20.3 5.9 99.5 275.000
## 12 12 48-59 75.6 20.8 3.2 99.6 313.000
## 13 13 Primary_or_less (67.6) (13.1) (14.0) (94.6) 33.000
## 14 14 Lower_secondary 57.2 20.1 22.7 100.0 163.000
## 15 15 Upper_secondary 61.0 20.8 16.9 98.8 799.000
## 16 16 Post_secondary_plus 65.6 20.5 13.5 99.6 432.000
## 17 17 Special_education (*) (*) (*) (*) 1.000
## 18 18 Missing/DK (*) (*) (*) (*) 3.000
## 19 19 Ha_functional_difficulty (48.4) (30.7) (17.3) (96.4) 34.000
## 20 20 Has_no_functional_difficulty 70.6 21.8 7.2 99.5 837.000
## 21 21 Black 61.7 20.6 16.7 99.0 1.343
## 22 22 Other 69.0 18.4 12.6 100.0 89.000
## 23 23 Church_of_God 62.3 22.6 14.6 99.5 437.000
## 24 24 Pentecostal 65.6 17.9 16.0 99.5 172.000
## 25 25 Seventh-day_Adventist 55.8 19.2 22.1 97.1 188.000
## 26 26 Other_religion/denomination 62.9 20.8 15.7 99.3 422.000
## 27 27 No_religion 62.8 18.8 17.4 98.9 207.000
## 28 28 Missing/DK (*) (*) (*) (*) 6.000
## 29 29 Poorest 52.1 24.3 20.9 97.3 331.000
## 30 30 Second 65.5 20.1 14.4 100.0 355.000
## 31 31 Middle 60.4 19.6 19.0 99.1 288.000
## 32 32 Fourth 64.7 19.1 15.4 99.1 251.000
## 33 33 Richest 71.8 17.8 10.4 100.0 208.000
## V7 V8
## 1 (*) 14
## 2 (*) 7
## 3 (*) 6
## 4 (*) 3
## 5 - 0
## 6 (*) 3
## 7 (*) 11
## 8 (*) 7
## 9 (*) 1
## 10 (*) 3
## 11 (*) 1
## 12 (*) 1
## 13 (*) 2
## 14 - 0
## 15 (*) 10
## 16 (*) 2
## 17 - 0
## 18 - 0
## 19 (*) 1
## 20 (*) 4
## 21 (*) 14
## 22 - 0
## 23 (*) 2
## 24 (*) 1
## 25 (*) 5
## 26 (*) 3
## 27 (*) 2
## 28 - 0
## 29 (*) 9
## 30 - 0
## 31 (*) 3
## 32 (*) 2
## 33 - 0