Data Preparation

• work with the documentation and codebooks to explain how the data is organized;
• copy files from one computer system or storage medium to another;
• extract subsets from large files;
• merge data;
• convert data among the standard formats used when working with data.

To Work with Data

• give pointers to appropriate techniques using examples, and a library of sample programs;
• explain program language syntax;
• advise on data manipulation techniques related to supported software & tools (Stata, R, SPSS, ArcGIS, QGIS, et al.);
• provide assistance in understanding and solving coding errors.

Instruction

• support learning statistical software (Stata, R, SPSS, et al.) and GIS software (ArcGIS, QGIS) by having manuals available and using computer-based training aids;
• give introductions to finding and using data either in the library or in class;
• prepare online user documentation and training aids.

• Research consultations are for current Columbia University affiliates and for original research purposes only. Users must have a valid UNI for service.
• We cannot help with homework assignments, provide tutoring, or aid in any non-original academic work. For this type of help, please contact your teaching assistant or professor.
• We also cannot provide assistance with projects that are commercial in nature, involve classified information or non-disclosure agreements, or are related to or likely to be involved in litigation, etc.