Databases
StackOverflow2013
Postsdbo
POR- get a single column from many columns
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POR- get a single column from many columns
    primarykey
    data
    text
    <p>I have wavelenghts from 350 to 2500 each one have data:</p> <pre><code>x350 x351 x352 x353 x354 ...... x2500 0.18 0.17 0.17 0.17 0.16 ...... 0.3 0.16 0.15 0.15 0.15 0.15 ...... 0.47 0.14 0.14 0.13 0.13 0.13 ...... 0.35 </code></pre> <p>I need to make one column without the name of the wavelenght and give to this new colum a name:</p> <pre><code>Wave 0.18 0.16 0.14 0.17 0.15 0.14 0.17 0.15 0.13 0.16 0.15 0.13 . . . 0.3 0.47 0.35 </code></pre> <p><code>m</code> is my file and the columns of the wavelenghts are from 17 col to 2167 col. I tried:</p> <pre><code>a &lt;- list(m[1:16,17:2167]) </code></pre> <p>but I get the list with the names of the columns in between:</p> <pre><code>list(structure(list(X350 = c(0.15723315, 0.138406682, 0.174909807, 0.143139974, 0.123193808, 0.154449448, 0.163255619, 0.126194713, 0.14327512, 0.066265248, 0.139851395, 0.158271497, 0.158060045, 0.145313933, 0.143890661), X351 = c(0.154324452, 0.135509959, 0.173350322, 0.139867145, 0.121439474, 0.15276091, 0.160391152, 0.125592826, 0.140349489, 0.065316491, 0.137927937, 0.158400317, 0.156211611, 0.142498763, 0.141353986), X352 = c(0.151243533.... </code></pre> <p>How can I get just one column with one name from 2465 columns?</p> <p>More info</p> <pre><code>str(m) 'data.frame': 16 obs. of 2167 variables: $ pott : int 48 49 50 51 52 53 54 55 56 57 ... $ b : chr "B1" "B1" "B1" "B1" ... $ F : int 1 1 1 1 1 1 1 1 1 1 ... $ G : chr "Sunstar" "Quarrion" "Nacozari" "W130114" ... $ R : int 3 3 3 3 3 3 3 3 3 3 ... $ D : int 80 80 81 80 81 80 82 82 82 82 ... $ W: num 1.8 1.5 1.3 1.9 1.8 1.25 1.85 2.1 1.6 2.4 ... $ S : num 43.4 35.7 44.7 48.6 45.3 35.5 49.2 49.1 46.8 41.5 ... $ R : num -0.327 1.149 2.348 1.636 1.952 ... $ V : num 76.4 49 118.9 108 114.5 ... $ J : num 158 114 191 169 183 ... $ P: num 19.9 10.6 24.1 21.1 23.6 ... $ Ce : num 0.367 0.13 0.466 0.36 0.462 ... $ Ci : num 273 246 280 263 272 ... $ S : num 23.5 29 30.9 29.4 24.1 ... $ L : num 42.5 34.4 32.4 34 41.4 ... $ X350 : num 0.176 0.157 0.138 0.175 0.143 ... $ X351 : num 0.172 0.154 0.136 0.173 0.14 ... $ X352 : num 0.169 0.151 0.133 0.172 0.138 ... $ X353 : num 0.167 0.147 0.132 0.17 0.137 ... $ X354 : num 0.165 0.147 0.13 0.167 0.133 ... $ X355 : num 0.162 0.146 0.127 0.166 0.13 ... $ X356 : num 0.159 0.144 0.126 0.164 0.128 ... $ X357 : num 0.158 0.14 0.125 0.161 0.125 ... $ X358 : num 0.155 0.138 0.123 0.159 0.124 ... $ X359 : num 0.153 0.137 0.121 0.157 0.123 ... $ X360 : num 0.15 0.135 0.12 0.154 0.122 ... ....$2500 </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJilber Urbina
    1. USuser1629515
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POR- get a single column from many columns
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POR- get a single column from many columns
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POR- get a single column from many columns
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COIt's hard to answer without knowing your data structure. Are you using a data.frame? In that case use `m[, 2167]`. I suggest you vastly simplify your data (say to a 5*5 matrix or data frame) and post the data in your question. Use `str(m)` or `dput(m)` to tell us the structure of your data.
      singulars
      1. POR- get a single column from many columns
      1. USAndrie
    2. CO> str(m) 'data.frame': 16 obs. of 2167 variables: $ Width: num 1.8 1.5 1.3 1.9 1.8 1.25 1.85 2.1 1.6 2.4 ... $ SPAD : num 43.4 35.7 44.7 48.6 45.3 35.5 49.2 49.1 46.8 41.5 ... $ Photo: num 19.9 10.6 24.1 21.1 23.6 ... $ Cond : num 0.367 0.13 0.466 0.36 0.462 ... $ Ci : num 273 246 280 263 272 ... $ X350 : num 0.176 0.157 0.138 0.175 0.143 ... $ X351 : num 0.172 0.154 0.136 0.173 0.14 ... .... and so on $ X2500
      singulars
      1. POR- get a single column from many columns
      1. USuser1629515
    3. COI was following pls package and I need the matrix (NIR) to use gas1 <- plsr(octane ~ NIR, ncomp = 10, data = gasTrain, validation = "LOO") NIR will be a column with all the waves and octane will be P.. this is the reason I guess that I need to make just one column with x350...x2500
      singulars
      1. POR- get a single column from many columns
      1. USuser1629515
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload