title: Select columns from a data frame
body: <p>I have a Data Frame made up of several columns, each corresponding to a different industry per country. I have 56 industries and 43 countries and I'd select only industries from 5 to 22 per country (18 industries). The big issue is that each industry per country is named as: AUS1, AUS2 ..., AUS56. What I shall select is AUS5 to AUS22, AUT5 to AUT22 ....
  A viable solution could be to select columns according to the following algorithm: the first column of interest, i.e., AUS5 corresponds to column 10 and then I select up to AUS22 (corresponding to column 27). Then, I should skip all the remaining column for AUS (i.e. AUS23 to AUS56), and the first 4 columns for the next country (from AUT1 to AUT4). Then, I select, as before, industries from 5 to 22 for AUT. Basically, the algorithm, starting from column 10 should be able to select 18 columns(including column 10) and then skip the next 38 columns, and then select the next 18 columns. This process should be repeated for all the 43 countries.
  How can I code that?</p>
  <p><strong>UPDATE, Example:</strong></p>
  <pre><code>df=data.frame(industry = c(&quot;C10&quot;,&quot;C11&quot;,&quot;C12&quot;,&quot;C13&quot;),
                     country = c(&quot;USA&quot;),
                     AUS3 = runif(4),
                     AUS4 = runif(4),
                     AUS5 = runif(4),
                     AUS6 = runif(4),
                     DEU5 = runif(4),
                     DEU6 = runif(4),
                     DEU7 = runif(4),
                     DEU8 = runif(4))
  #I'm interested only in C10-c11:
  
  df_a=df %&gt;% filter(grepl('C10|C11',industry))
  df_a
  
  #Thus, how can I select columns AUS10,AUS11, DEU10,DEU11 efficiently, considering that I have a huge dataset?
  
  </code></pre>