Am trying to import a dataset using read.tsv
Test <- read_tsv(file = "test.tsv", quote= "")
Test <- read.table("test.tsv", sep="\t", header=T,quote="", comment.char="", stringsAsFactors=F)
however in both ways it fails and gives me an weird result
Parsed with column specification:
cols(
D = col_logical(),
col_logical(),
_1 = col_logical(),
_2 = col_logical(),
_3 = col_logical(),
_4 = col_logical(),
_5 = col_logical(),
_6 = col_logical(),
_7 = col_logical(),
_8 = col_logical(),
_9 = col_logical(),
_10 = col_logical(),
_11 = col_logical(),
_12 = col_logical(),
_13 = col_logical()
)
Warning: 463968 parsing failures.
row col expected actual file
1 D 1/0/T/F/TRUE/FALSE 'test.tsv'
1 -- 15 columns 1 columns 'test.tsv'
2 D 1/0/T/F/TRUE/FALSE 'test.tsv'
2 1/0/T/F/TRUE/FALSE 'test.tsv'
2 _1 1/0/T/F/TRUE/FALSE 'test.tsv'
... ... .................. ......... ............................
See problems(...) for more details.
My test dataset is below :
| Department | Division | Name | Sub Id | Btype | main_group | main_classification | Screen | Description | Contributor | Foreground (Min.) | Background (Min.) | Minimized (Min.) | Locked (Min.) | Hits |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CSO | CF | C, An | 36 | BA | Analytics | Analytics | BC29 | Municipal Bonds | 1.21 | 105.2 | 0.84 | 40.23 | 1 | |
| CSO | CF | C, An | 36 | BA | Analytics | Analytics | YAS | Yield & Spread Analysis | 13.22 | 1482.75 | 101.03 | 833.96 | 26 | |
| CSO | CF | C, An | 36 | BA | BSP | Not-Relevant (NR) | EIS | Exchange Info Systems | 0 | 0 | 0 | 0 | 1 | |
| CSO | CF | C, An | 36 | BA | BSP | Not-Relevant (NR) | HELP | BHS | 1 | 0 | 0 | 0 | 16 |
Please help