School of Global Policy and Strategy (GPS) - Skills Courses

Date: Jan 10 - Mar 9, 2023

Time: 2:00 pm - 3:20 pm

Venue: School of Global Policy and Strategy (GPS) - Skills Courses

Instructors: Reid Otsuji (Library), Stephanie Labou (Library), Kimberly Thomas (Research ITS), Eastern Kang (Pediatrics), Carolina Dantas (Medicine), Rukmini Ravi (SDSC)

Helpers: Kimberly Thomas (Research ITS), Celeste Allaband (Pediatrics), Reid Otsuji (Library), TA: Pending (GPS)

This is the website for the School of Global Policy and Strategy Skills Courses. In order to earn a certificate of proficiency, you must attend all of the class meetings for the course, do the short assignments, and pass the quizzes.

Who: The course is aimed at GPS graduate students. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Requirements: Participants must bring a laptop with a few specific software packages installed (listed below).

Contact: Please mail kkt008@ucds.edu, spsardesai@ucsd.edu, rotsuji@ucsd.edu for more information.

Assessment: A certificate of proficiency will be given to students who:

  • Attend/view all classes
  • Passes quizzes
  • Satisfactorily completes the weekly assignments

Data:

  • Download the survey.db and put it on your desktop inside a folder labeled "sql" .

Need help?:


Credits: The course materials are adpated from the Carpentries lessons. Many thanks to the authors of those lessons.

GPS Skills Course Schedule

Dates Course Syllabus
Jan 10 - Jan 26 Python Skills Course Running and Quitting; Variables and Assignment; Data Types and Type Conversion; Built-in Functions and Help; Libraries; Errors & Exceptions; Reading Tabular Data into DataFrames; Pandas Dataframes; Plotting; Lists; For Loops; Conditionals; Looping Over Data Sets; Writing Functions
Jan 31 - Feb 16 R Skills Course Introduction to R and RStudio; Seeking Help; Data Structures; Exploring Data Frames; Dataframe manipulation with dplyr; Data Frame Manipulation with tidyr; Plotting with ggplot2; Control Flow; Producing Reports with knitr
Feb 21 - Mar 9 Data Management Skills Course Intro to the Unix Shell; Git & Github; DM Best Practices; Tidy Data; SQL

Curriculum

For this workshop we will be referencing the R for Reproducible Scientific Analysis, Introduction to R for Geospatial Data Plotting and Programming in Python, The UNIX Shell, Library Carpentry: Introduction to Git , Library Carpentry: SQL, Databases and SQL, and Data Organization in Spreadsheets for Social Scientists Carpentries curricula.


Collaborative

We will use HackMD for collaborative notes, sharing URLs and bits of code.
Python Course HackMD: https://hackmd.io/@kkt008/gps-python-2023.
R Course HackMD: https://hackmd.io/@kkt008/gps-r-2023.
DM Course HackMD: https://hackmd.io/@kkt008/gps-dm-2023.


Setup

To participate in this workshop, you will need access to the software described below. In addition, you will need an up-to-date web browser.

R

R is a programming language that is especially powerful for data exploration, visualization, and statistical analysis. To interact with R, we use RStudio.

Install R by downloading and running this .exe file from CRAN. Also, please install the RStudio IDE. Note that if you have separate user and admin accounts, you should run the installers as administrator (right-click on .exe file and select "Run as administrator" instead of double-clicking). Otherwise problems may occur later, for example when installing R packages.

Video Tutorial: SWC R Install Windows

Install R by downloading and running this .pkg file from CRAN. Also, please install the RStudio IDE.

Video Tutorial: SWC R Install Mac

Instructions for R installation on various Linux platforms (debian, fedora, redhat, and ubuntu) can be found at . These will instruct you to use your package manager (e.g. for Fedora run sudo dnf install R and for Debian/Ubuntu, add a ppa repository and then run sudo apt-get install r-base). Also, please install the RStudio IDE.

Python

We will teach Python using the Jupyter Notebook, a programming environment that runs in a web browser (Jupyter Notebook will be installed by Anaconda). For this to work you will need a reasonably up-to-date browser. The current versions of the Chrome, Safari and Firefox browsers are all supported (some older browsers, including Internet Explorer version 9 and below, are not).

  1. Open https://www.anaconda.com/products/individual#download-section with your web browser.
  2. Download the Anaconda for Windows installer with Python 3. (If you are not sure which version to choose, you probably want the 64-bit Graphical Installer Anaconda3-...-Windows-x86_64.exe)
  3. Install Python 3 by running the Anaconda Installer, using all of the defaults for installation except make sure to check Add Anaconda to my PATH environment variable.

Video Tutorial: SWC Install Python on Windows

  1. Open https://www.anaconda.com/products/individual#download-section with your web browser.
  2. Download the Anaconda Installer with Python 3 for macOS (you can either use the Graphical or the Command Line Installer).
  3. Install Python 3 by running the Anaconda Installer using all of the defaults for installation.

Video Tutorial: SWC Install Python on Mac

  1. Open https://www.anaconda.com/products/individual#download-section with your web browser.
  2. Download the Anaconda Installer with Python 3 for Linux.
    (The installation requires using the shell. If you aren't comfortable doing the installation yourself stop here and request help at the workshop.)
  3. Open a terminal window and navigate to the directory where the executable is downloaded (e.g., `cd ~/Downloads`).
  4. Type
    bash Anaconda3-
    and then press Tab to autocomplete the full file name. The name of file you just downloaded should appear.
  5. Press Enter (or Return depending on your keyboard). You will follow the text-only prompts. To move through the text, press Spacebar. Type yes and press enter to approve the license. Press Enter (or Return) to approve the default location for the files. Type yes and press Enter (or Return) to prepend Anaconda to your PATH (this makes the Anaconda distribution the default Python).
  6. Close the terminal window.

The Bash Shell

Bash is a commonly-used shell that gives you the power to do tasks more quickly.

  1. Download the Git for Windows installer.
  2. Run the installer and follow the steps below:

      Git 2.27.0 Setup

    1. Click on "Next" four times (two times if you've previously installed Git). You don't need to change anything in the Information, location, components, and start menu screens.
    2. From the dropdown menu select "Use the nano editor by default" and click on "Next".
    3. Adjusting your PATH environment

    4. Ensure that "Git from the command line and also from 3rd-party software" is selected and click on "Next". (If you don't do this Git Bash will not work properly, requiring you to remove the Git Bash installation, re-run the installer and to select the "Git from the command line and also from 3rd-party software" option.)
    5. Choosing the SSH executable

      Choosing HTTPS transport backend

    6. Ensure that "Use the native Windows Secure Channel library" is selected and click on "Next".
    7. This should mean that people stuck behind corporate firewalls that do MITM attacks with their own root CA are still able to access remote git repos.

      Configuring the line ending conversions

    8. Ensure that "Checkout Windows-style, commit Unix-style line endings" is selected and click on "Next".
    9. Configuring the terminal emulator to use with Git Bash

    10. Ensure that "Use Windows' default console window" is selected and click on "Next".
    11. Configuring extra options

    12. Ensure that "Default (fast-forward or merge) is selected and click "Next"
    13. Ensure that "Enable file system caching" and "Enable Git Credential Manager" are selected and click on "Next".
    14. Configuring experimental options

    15. Click on "Install".
    16. Installing

      Completing the Git Setup Wizard

      as of 2020-06-02, the Window will say "click Finish", but the button is labelled as "Next"

    17. Click on "Finish" or "Next".
  3. If your "HOME" environment variable is not set (or you don't know what this is):
    1. Open command prompt (Open Start Menu then type cmd and press Enter)
    2. Type the following line into the command prompt window exactly as shown:

      setx HOME "%USERPROFILE%"

    3. Press Enter, you should see SUCCESS: Specified value was saved.
    4. Quit command prompt by typing exit then pressing Enter

This will provide you with both Git and Bash in the Git Bash program.

Video Tutorial: Windows Installation

The default shell in some versions of macOS is Bash, and Bash is available in all versions, so no need to install anything. You access Bash from the Terminal (found in /Applications/Utilities). See the Git installation video tutorial for an example on how to open the Terminal. You may want to keep Terminal in your dock for this workshop.

To see if your default shell is Bash type echo $SHELL in Terminal and press the Return key. If the message printed does not end with '/bash' then your default is something else and you can run Bash by typing bash

If you want to change your default shell, see this Apple Support article and follow the instructions on "How to change your default shell".

Video Tutorial MacOS Installation

The default shell is usually Bash and there is usually no need to install anything.

To see if your default shell is Bash type echo $SHELL in a terminal and press the Enter key. If the message printed does not end with '/bash' then your default is something else and you can run Bash by typing bash.

Git

Git is a version control system that lets you track who made changes to what when and has options for easily updating a shared or public version of your code on github.com. You will need a supported web browser.

You will need an account at github.com for parts of the Git lesson. Basic GitHub accounts are free. We encourage you to create a GitHub account if you don't have one already. Please consider what personal information you'd like to reveal. For example, you may want to review these instructions for keeping your email address private provided at GitHub.

Git should be installed on your computer as part of your Bash install (see the Shell installation instructions).

For macOS, install Git for Mac by downloading and running the most recent "mavericks" installer from this list. Because this installer is not signed by the developer, you may have to right click (control click) on the .pkg file, click Open, and click Open on the pop up window. After installing Git, there will not be anything in your /Applications folder, as Git is a command line program. For older versions of OS X (10.5-10.8) use the most recent available installer labelled "snow-leopard" available here.

Video Tutorial: SWC Install Shell, Git, and Nano on Mac

If Git is not already available on your machine you can try to install it via your distro's package manager. For Debian/Ubuntu run sudo apt-get install git and for Fedora run sudo dnf install git.