Only loading the library for the session Information
library(knitr)
The following user defined function works:
grep
and find
are two utilities for searching, grep
searches for content within files, find
searches for file names themselves.
Defining some additional options in grep allows searching using colour where filenames and row positions are highlighted.
// Use Gists to store code you would like to remember later on | |
console.log(window); // log the "window" object to the console |
- Click anywhere within the data table | |
- Hit the key combination Alt - d - p to bring up the Pivot Table Wizard (which is not on the ribbon) | |
- Select "Multiple consolidation ranges" and click Next | |
- Select "I will create the page fields" and click Next | |
- Select your data table (in the example it's A1:E11) and click Next | |
- Select the location and click Next | |
Now you will see a pivot table that looks just like your data table | |
- Click the Pivot table and in the field list uncheck Row and Column (and uncheck any Page Field, if present) | |
- Now select the cell with the single remaining total number and double click it. | |
The result is a new sheet with your data laid out one item per row. |
There are a huge range of tutorials and books available for learning Python. There are a couple things to watch out for when selecting learning material:
Bellow is a list of resources that are generally more focussed towards science and numerical programming rather than other topics (e.g. web development). I have used parts of most of these or otherwise trust the source of the material.