Hey,
i am new here and i am just a R-Studio basics user. But I am very impressed by the possibilitys R Studio got!
I hope somebody can help me with the following task.
My table looks like:
.txt
H | Ti | ID | mer | Z | L | MT | Mik | F | E | Hst | F_E | e | R | xy |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | Christina | 3 | 587 | 54572 | 3 | 5 | 37,9 | 5,99 | 3,58 | 250 | 1,7** | 47,1 | 5 | |
20 | 3 | 598 | 27377 | 2 | 7 | 38,7 | 3,47 | 3,45 | 146 | 1 | 36,5 | 4 | ||
192 | Betina | 3 | 608 | 33915 | 1 | 8 | 24,6 | 6,19 | 3,5 | 276 | 1,8** | 31 | 5 | |
2 | Antje | 3 | 608 | 33881 | 1 | 10 | 32,5 | 4,18 | 3,31 | 126 | 1,3 | 33 | 4 | |
65 | Soleika | 3 | 608 | 33887 | 1 | 11 | 32,1 | 4,29 | 3,08 | 140 | 1,4 | 32,6 | 4 | |
179 | Carmen | 3 | 587 | 54567 | 3 | 11 | 41,3 | 4,53 | 3,15 | 125 | 1,4 | 43,2 | 4 | |
17 | Gundula | 3 | 598 | 27413 | 2 | 13 | 44,1 | 3,68 | 3,42 | 211 | 1,1 | 42,6 | 5 | |
71 | Annika | 3 | 598 | 27454 | 1 | 14 | 30,7 | 5,23 | 3,22 | 255 | 1,6** | 34,8 | 5 | |
89 | Erna | 3 | 608 | 33888 | 1 | 16 | 35,8 | 4,03 | 3,16 | 111 | 1,3 | 35,4 | 4 | |
152 | Erle | 3 | 598 | 27408 | 2 | 19 | 55 | 3,33 | 2,97 | 145 | 1,1 | 49,3 | 1 | |
136 | Emily | 3 | 587 | 54569 | 3 | 23 | 56 | 4,03 | 3,22 | 200 | 1,3 | 55,6 | 5 | |
56 | Paola | 3 | 587 | 54607 | 3 | 24 | 46,1 | 4,04 | 3,01 | 238 | 1,3 | 45,2 | 2 | |
121 | 3 | 598 | 27376 | 2 | 25 | 35,9 | 3,67 | 3,67 | 210 | 1 | 35,2 | 5 | ||
98 | 3 | 587 | 54558 | 3 | 32 | 40,9 | 3,3 | 3,09 | 153 | 1,1 | 36,8 | 5 | ||
182 | Anja | 3 | 608 | 33892 | 1 | 35 | ?39,0 | 3,41 | 2,98 | 212 | 1,1 | 35,3 | 2 | |
93 | Paola | 3 | 587 | 54576 | 3 | 56 | 59,2 | 2,6 | 2,95 | 156 | 0,9 | * | 48 | 2 |
There are following basics and problems by coloumn:
H. these is ok
Ti,. could be a name or a n.a but n.a is not recognized when saved as .txt so values are moved from the following coloumn "ID" to these coloumn
ID. is always a "3" and i thing a good argument for coding??
mer. always a count of three numbers but not the same in each line
Z. always a count of five numbers but not the same in each line
L. always one number but not the same in each line (sometimes it could go up to two numbers - very rare)
MT. a count from one up to three numbers but not the same in each line (these increases from the first to the last line - here 5 (first line H=27) .... 56 (last line H=93)
Mik. a count of up to three numbers. One or two in front and one after a "," and sometimes there is an aditional "↑" or "↓" in the front of the number (here it is a "?" not the "↑" - e.g. line H=182)
F. a count of three numbers. One in front and one or tow after a ","
E. a count of three numbers. One in front and one or tow after a ","
Hst. a count of three numbers sometimes aditional "" after the count
F_E a count of tow numbers separated by "," one in front one after the "," - sometimes aditional " *" (recognize the space in front of *) or "" (without a space) after the count
e. a count of up to three numbers. One or two in front and one after a ","
R. a singel number
xy. contains the number belonging to coloumn R which are moved through saving as .txt and would not exist in the original .pdf
In the end all "↓" or "↑" (here"?") or " *" or "**" should be removed and the counts should be in the correct coloumn.... as:
H | Ti | ID | mer | Z | L | MT | Mik | F | E | Hst | F_E | e | R | xy |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27 | Christina | 3 | 587 | 54572 | 3 | 5 | 37,9 | 5,99 | 3,58 | 250 | 1,7 | 47,1 | 5 | |
20 | Christinaa | 3 | 598 | 27377 | 2 | 7 | 38,7 | 3,47 | 3,45 | 146 | 1 | 36,5 | 4 | |
192 | Betina | 3 | 608 | 33915 | 1 | 8 | 24,6 | 6,19 | 3,5 | 276 | 1,8 | 31 | 5 | |
2 | Antje | 3 | 608 | 33881 | 1 | 10 | 32,5 | 4,18 | 3,31 | 126 | 1,3 | 33 | 4 | |
65 | Soleika | 3 | 608 | 33887 | 1 | 11 | 32,1 | 4,29 | 3,08 | 140 | 1,4 | 32,6 | 4 | |
179 | Carmen | 3 | 587 | 54567 | 3 | 11 | 41,3 | 4,53 | 3,15 | 125 | 1,4 | 43,2 | 4 | |
17 | Gundula | 3 | 598 | 27413 | 2 | 13 | 44,1 | 3,68 | 3,42 | 211 | 1,1 | 42,6 | 5 | |
71 | Annika | 3 | 598 | 27454 | 1 | 14 | 30,7 | 5,23 | 3,22 | 255 | 1,6 | 34,8 | 5 | |
89 | Erna | 3 | 608 | 33888 | 1 | 16 | 35,8 | 4,03 | 3,16 | 111 | 1,3 | 35,4 | 4 | |
152 | Erle | 3 | 598 | 27408 | 2 | 19 | 55 | 3,33 | 2,97 | 145 | 1,1 | 49,3 | 1 | |
136 | Emily | 3 | 587 | 54569 | 3 | 23 | 56 | 4,03 | 3,22 | 200 | 1,3 | 55,6 | 5 | |
56 | Paola | 3 | 587 | 54607 | 3 | 24 | 46,1 | 4,04 | 3,01 | 238 | 1,3 | 45,2 | 2 | |
121 | Christinaaa | 3 | 598 | 27376 | 2 | 25 | 35,9 | 3,67 | 3,67 | 210 | 1 | 35,2 | 5 | |
98 | Christinaaaa | 3 | 587 | 54558 | 3 | 32 | 40,9 | 3,3 | 3,09 | 153 | 1,1 | 36,8 | 5 | |
182 | Anja | 3 | 608 | 33892 | 1 | 35 | 39,0 | 3,41 | 2,98 | 212 | 1,1 | 35,3 | 2 | |
93 | Paola | 3 | 587 | 54576 | 3 | 56 | 59,2 | 2,6 | 2,95 | 156 | 0,9 | 48 | 2 |
all "n.a" Ti are filled with "Christina" plus an aditional "a" retrospective the last "Christina" up in the table
If there is anyone who can help... please !
I am a newb................
Best regards!