After transposing my data I am right now at this stage:
| Alex Aro | Billie Piper | Chris Fe | Daron Chlim | Erik Fuc | (3000 more names) |
|---|
Only headers, but no data inside. Now I want to populate the empty dataframe like this:
| Alex Aro | Billie Piper | Chris Fe | Daron Chlim | Erik Fuc | (3000 more names) |
|---|---|---|---|---|---|
| NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA |
| NA | NA | NA | NA | NA | NA |
| (18 000 rows) | NA | NA | NA | NA | NA |
It does not matter if I have zeros or NA in the end. As you can see lots of rows and columns, so code is only useful if I do not have to type every row and column by myself. Thanks in advance!
