Hello to all,
Hi I'm new here and I'm trying to learn how to use this program with a not quite simple case. (I'm a beginner in general with programming).
I'm having some problems with RStudio because I'm working with a really big file:
It is a file of 49966 rows (the first row is the name and follow rows my element name and bit ex. 1 0 1 0 0) and 1024 columns (the first column is the name, then a series of 1 and 0). I have everything saved on an excel file. I would also like to specify that the name is also a number!
example:
NAME
123 1 0 1 1 1 1 1 1
352 0 0 0 0 1 1 0 0
first problem why only 256? I have 1024 variables
str(mydata)
'data.frame': 49965 obs. of 256 variables:
NAME : int 3000300 3000350 3007493 3013793 3013798 3013808 3013817 3013821 3013825 3013838 ...
X : int 0 0 0 0 0 0 0 0 0 1 ...
X.1 : int 0 0 0 0 0 0 0 0 0 0 ...
X.2 : int 0 0 0 0 0 0 0 0 0 0 ...
X.3 : int 0 1 0 0 0 0 1 0 0 0 ...
X.4 : int 0 0 0 0 0 0 0 0 0 0 ...
X.5 : int 0 0 0 0 0 0 0 0 0 0 ...
X.6 : int 0 0 0 0 0 0 0 0 0 0 ...
X.7 : int 0 0 0 0 0 0 0 0 0 0 ...
X.8 : int 0 0 0 0 0 0 0 0 0 0 ...
X.9 : int 0 0 0 0 0 0 0 0 0 0 ...
X.10 : int 0 0 0 0 0 0 0 0 0 0 ...
X.11 : int 0 0 0 0 0 0 0 0 0 0 ...
X.12 : int 0 0 0 0 0 0 0 0 0 0 ...
X.13 : int 0 0 0 0 0 0 0 0 0 0 ...
X.14 : int 1 0 0 0 0 0 0 0 0 0 ...
X.15 : int 0 0 0 0 0 0 0 0 0 0 ...
X.16 : int 0 0 0 0 0 0 0 0 0 0 ...
X.17 : int 0 0 0 0 0 0 0 0 0 0 ...
X.18 : int 0 0 0 0 0 0 0 0 0 0 ...
X.19 : int 0 0 0 0 0 0 0 0 0 0 ...
X.20 : int 0 0 0 0 0 0 0 0 0 0 ...
X.21 : int 0 0 0 0 0 0 0 0 0 0 ...
X.22 : int 0 0 1 0 0 0 0 0 0 0 ...
X.23 : int 0 0 0 0 0 0 0 0 0 0 ...
X.24 : int 0 0 0 0 0 0 0 0 0 0 ...
X.25 : int 0 0 0 0 0 0 0 0 0 0 ...
X.26 : int 0 0 0 0 0 0 0 0 0 0 ...
X.27 : int 0 0 0 0 0 0 0 0 0 0 ...
X.28 : int 0 0 0 0 0 0 0 0 0 0 ...
X.29 : int 0 0 0 0 0 0 0 0 0 0 ...
X.30 : int 0 0 0 0 0 0 0 0 0 0 ...
X.31 : int 0 0 0 0 0 0 0 0 0 0 ...
X.32 : int 1 0 1 1 0 1 0 0 0 1 ...
X.33 : int 0 0 0 0 0 0 0 0 0 0 ...
X.34 : int 0 0 0 0 0 0 0 0 0 0 ...
X.35 : int 0 0 0 0 0 0 0 0 0 0 ...
X.36 : int 0 0 0 0 0 0 0 0 0 0 ...
X.37 : int 0 0 0 0 0 0 0 0 0 0 ...
X.38 : int 0 0 0 0 0 0 0 0 0 0 ...
X.39 : int 0 0 0 0 0 0 0 0 0 0 ...
X.40 : int 0 0 0 0 0 0 0 0 0 0 ...
X.41 : int 0 1 0 0 0 0 0 0 0 0 ...
X.42 : int 0 0 0 0 0 0 0 0 0 0 ...
X.43 : int 0 0 0 0 0 0 0 0 0 0 ...
X.44 : int 0 0 0 0 0 0 0 0 0 0 ...
X.45 : int 0 0 0 0 0 0 0 0 0 0 ...
X.46 : int 0 0 0 0 0 0 0 0 0 0 ...
X.47 : int 0 0 0 0 0 0 0 0 0 0 ...
X.48 : int 0 0 0 0 0 0 0 0 0 0 ...
X.49 : int 0 0 0 0 0 0 0 0 0 0 ...
X.50 : int 0 0 0 0 0 0 0 0 0 0 ...
X.51 : int 0 0 0 0 0 0 0 0 0 0 ...
X.52 : int 0 0 0 0 0 0 0 0 0 0 ...
X.53 : int 0 0 0 0 0 0 0 0 0 0 ...
X.54 : int 0 0 0 0 0 0 0 0 0 0 ...
X.55 : int 0 0 0 0 0 0 0 0 0 0 ...
X.56 : int 0 0 0 0 0 0 0 0 1 0 ...
X.57 : int 0 0 0 0 0 0 0 0 0 0 ...
X.58 : int 0 0 0 0 0 0 0 0 0 0 ...
X.59 : int 0 0 0 0 0 0 0 0 0 0 ...
X.60 : int 0 0 1 0 0 0 0 0 0 0 ...
X.61 : int 0 0 0 0 0 0 0 0 0 0 ...
X.62 : int 0 0 0 0 0 0 0 0 0 0 ...
X.63 : int 1 0 0 0 0 0 0 0 1 1 ...
X.64 : int 0 0 0 0 0 0 0 0 0 0 ...
X.65 : int 0 0 0 0 0 0 0 0 0 0 ...
X.66 : int 0 0 0 0 0 0 0 0 0 0 ...
X.67 : int 0 0 0 0 0 0 0 0 0 0 ...
X.68 : int 1 0 0 0 0 0 0 0 0 0 ...
X.69 : int 0 0 0 0 0 0 0 0 0 0 ...
X.70 : int 0 0 0 0 0 0 0 0 0 0 ...
X.71 : int 0 0 0 0 0 0 0 0 0 0 ...
X.72 : int 0 0 0 0 0 0 0 0 0 0 ...
X.73 : int 0 0 0 0 0 0 0 0 0 0 ...
X.74 : int 0 0 0 0 0 0 0 0 0 0 ...
X.75 : int 0 0 0 0 0 0 0 0 0 0 ...
X.76 : int 0 0 0 0 0 0 0 0 0 0 ...
X.77 : int 0 0 0 0 0 0 0 0 0 0 ...
X.78 : int 0 0 0 0 0 0 0 0 0 0 ...
X.79 : int 1 0 1 1 1 1 1 1 1 0 ...
X.80 : int 0 0 0 0 0 0 0 0 0 0 ...
X.81 : int 0 0 0 0 0 0 0 0 0 0 ...
X.82 : int 0 0 0 0 0 0 0 0 0 0 ...
X.83 : int 0 0 0 0 0 0 0 0 0 0 ...
X.84 : int 0 0 0 0 0 0 0 0 0 0 ...
X.85 : int 0 0 0 1 0 0 0 1 0 0 ...
X.86 : int 0 0 0 0 0 0 0 0 0 0 ...
X.87 : int 0 0 0 0 0 0 0 0 0 0 ...
X.88 : int 0 0 0 0 0 0 0 0 0 0 ...
X.89 : int 0 0 0 0 0 0 0 0 0 0 ...
X.90 : int 0 0 0 0 0 0 0 0 0 0 ...
X.91 : int 0 0 0 0 0 0 0 0 0 0 ...
X.92 : int 0 0 0 0 0 0 0 0 0 0 ...
X.93 : int 0 0 0 0 1 0 0 1 0 0 ...
X.94 : int 0 0 0 0 0 0 0 0 0 0 ...
X.95 : int 0 0 0 0 0 0 0 0 0 0 ...
X.96 : int 0 0 0 0 0 0 0 0 0 0 ...
$ X.97 : int 0 0 0 0 0 0 0 0 0 0 ...
[list output truncated]
head(mydata)
NAME X X.1 X.2 X.3 X.4 X.5 X.6 X.7 X.8 X.9 X.10 X.11 X.12 X.13 X.14 X.15
1 3000300 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
2 3000350 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
3 3007493 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X.16 X.17 X.18 X.19 X.20 X.21 X.22 X.23 X.24 X.25 X.26 X.27 X.28 X.29 X.30
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0
X.31 X.32 X.33 X.34 X.35 X.36 X.37 X.38 X.39 X.40 X.41 X.42 X.43 X.44 X.45
1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0
3 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
X.46 X.47 X.48 X.49 X.50 X.51 X.52 X.53 X.54 X.55 X.56 X.57 X.58 X.59 X.60
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
X.61 X.62 X.63 X.64 X.65 X.66 X.67 X.68 X.69 X.70 X.71 X.72 X.73 X.74 X.75
1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X.76 X.77 X.78 X.79 X.80 X.81 X.82 X.83 X.84 X.85 X.86 X.87 X.88 X.89 X.90
1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0
X.91 X.92 X.93 X.94 X.95 X.96 X.97 X.98 X.99 X.100 X.101 X.102 X.103 X.104
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0 0
X.105 X.106 X.107 X.108 X.109 X.110 X.111 X.112 X.113 X.114 X.115 X.116 X.117
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.118 X.119 X.120 X.121 X.122 X.123 X.124 X.125 X.126 X.127 X.128 X.129 X.130
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.131 X.132 X.133 X.134 X.135 X.136 X.137 X.138 X.139 X.140 X.141 X.142 X.143
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.144 X.145 X.146 X.147 X.148 X.149 X.150 X.151 X.152 X.153 X.154 X.155 X.156
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 1 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.157 X.158 X.159 X.160 X.161 X.162 X.163 X.164 X.165 X.166 X.167 X.168 X.169
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 1 0 0 0 0 1 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.170 X.171 X.172 X.173 X.174 X.175 X.176 X.177 X.178 X.179 X.180 X.181 X.182
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.183 X.184 X.185 X.186 X.187 X.188 X.189 X.190 X.191 X.192 X.193 X.194 X.195
1 1 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.196 X.197 X.198 X.199 X.200 X.201 X.202 X.203 X.204 X.205 X.206 X.207 X.208
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 1
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.209 X.210 X.211 X.212 X.213 X.214 X.215 X.216 X.217 X.218 X.219 X.220 X.221
1 0 0 0 0 1 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.222 X.223 X.224 X.225 X.226 X.227 X.228 X.229 X.230 X.231 X.232 X.233 X.234
1 0 0 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.235 X.236 X.237 X.238 X.239 X.240 X.241 X.242 X.243 X.244 X.245 X.246 X.247
1 0 1 0 0 0 0 0 0 0 0 0 0 0
2 0 0 0 0 1 0 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0 0 0 0 0 0 0
X.248 X.249 X.250 X.251 X.252 X.253 X.254
1 0 0 0 0 0 0 0
2 0 0 0 0 0 0 0
3 0 0 0 0 0 0 0
[ reached 'max' / getOption("max.print") -- omitted 3 rows ]
But I don't care if you don't show it to me. The problem is here:
pairs(mydata)
Error in plot.new() : figure margins too large
Is it possible to solve it in some way? Use another system to view such a large file? Or save it directly?
Thank you all for those who will help me!