Introduction
  • Introduction
  • Using nitroproc on Android
  • Using nitroproc on iOS
  • Nitroproc on MacOS
  • Nitroproc on Windows - Installing it
  • Syntax
General topics
  • Adding your own data - Android
  • Adding your own data - iOS
  • Using the data viewer
  • Available column types - the coltypes= parameter
  • Column types : the coltypes parameter - Android/iOS example
Outputs
  • The log file
  • The tracer file
sorting data : the sort statement
  • sort on PC/Mac - detailed analysis
  • sort on Android/iOS
Selecting different combinations by a set of keys: the select_distinct statement
  • select_distinct on PC/Mac - detailed analysis
  • select_distinct on Android/iOS
Grouping data and creating aggregate metrics: the summary statement
  • summary on Android/iOS
Wide to long and long to wide : the widetolong and longtowiide statements
  • widetolong on PC/Mac - detailed analysis
  • Longtowide on PC/Mac - detailed analysis
  • widetolong and longtowide on Android/iOS
Merging files: the merge statement
  • merge on PC/Mac - detailed analysis
  • merge on Android/iOS
Reordering columns: the reorder_cols statement
  • reorder_cols on PC/Mac - detailed analysis
  • reorder_cols on Android/iOS
Statistics using Linear regression: the linear_regression statement
  • linear_regression on PC/Mac - detailed analysis
  • linear_regression on Android/iOS
Creating dummies: the dummies statement
  • dummies on PC/Mac - detailed analysis
  • dummies on Android/iOS
Machine learning with Random forests
  • random_forest on PC/Mac - detailed analysis
  • random_forest on Android/iOS
Machine learning with Gradient boosting
  • gradient_boosting on PC/Mac - detailed analysis
  • gradient boosting on Android/iOS
Machine learning with Extra-trees
  • extra_trees on PC/Mac - detailed analysis
  • extra_trees on Android/iOS
Renaming files: the rename statement
  • rename on PC/Mac - detailed analysis
  • rename on Android/iOS
Subsetting columns: the subset statement
  • subset on PC/Mac - detailed analysis
  • subset on Android/iOS
Subsetting rows : the where statement
  • where on PC/Mac - detailed analysis
  • where on Android/iOS
Vertical append: the vappend statement
  • vappend on PC/Mac - detailed analysis
  • vappend on Android/iOS
Horizontal append: the happend statement
  • happend on PC/Mac - detailed analysis
  • happend on Android/iOS
Replacing missing values : the replace_missing statement
  • replace_missing on PC/Mac - detailed analysis
  • replace_missing on Android/iOS
Creating new variables: the generate statement
  • generate on PC/Mac - detailed analysis
  • generate on Android/iOS
Splitting training and testing data: the traintest_split statement
  • traintest_split on PC/Mac - detailed analysis
  • traintest_split on Android/iOS
Removing files : the remove statement
  • remove on PC/Mac - detailed analysis
Removing the first row in files: the remove_first statement
  • remove_first on PC/Mac - detailed analysis
  • remove_first on Android/iOS
Exclusion joins: the ifAnotB statement
  • ifAnotB on PC/Mac - detailed analysis
  • ifAnotB on Android/iOS
Slicing a dataset: the slice statement
  • slice on PC/Mac - detailed analysis
  • slice on Android/iOS
Checking data types : the verify statement
  • verify on PC/Mac - detailed analysis
  • verify on Android/iOS
Batch mode
  • Running nitroproc in batch mode - calling it thru Python/R/VB
  • Python and R code