Amanda Devine amdevine

SQL Challenges

Attendance Question

What is your favorite thing you learned yesterday about spreadsheets or OpenRefine?

Carpentries Brown Bag - Querying data from database API services with Python Requests: https://github.com/amdevine/cbb-python-requests

Data Carpentry: Python Day 1

These notes are adapted from the official Carpentries documentation for Data Analysis and Visualization in Python for Ecologists: Before we start. They have been reordered, and some material has been expanded on, and there are some Smithsonian-specific details incorporated. The original lessons are licensed under CC-BY 4.0 2018–2020 by The Carpentries. These adapted notes are available for use under the same license.

Links

Official lesson link: https://datacarpentry.org/python-ecology-lesson/

Jupyter documentation: https://datacarpentry.org/python-ecology-lesson/jupyter_notebooks/

Vertebrate Classes

This gist contains all classes that occur in phylum Chordata for each data source, and whether these classes would be classified as vertebrates for the purpose of analysis.

Catalogue of Life

Class	Vertebrate?	Category
Actinopterygii	Yes	Fishes
Amphibia	Yes	Amphibians and Reptiles

Terrestrial Arthropod Classes

This gist contains all classes that occur in phylum Arthropoda for each data source, and whether these classes would be classified as "terrestrial arthropods" when doing analyses.

Catalogue of Life

Class	Terrestrial Arthropod
Arachnida	Yes
~~Branchiopoda~~	No

Text was taken from Stackoverflow, user emk. https://stackoverflow.com/a/72156

First, clone a remote Git repository and cd into it:

$ git clone git://example.com/myproject
$ cd myproject

Next, look at the local branches in your repository:

Data Carpentry - SQL Cheat Sheet

Query order of operations

SELECT tablea.column1, tablea.column2, tableb.column3 AS somealias, SUM(tableb.column4)
FROM tablea
LEFT JOIN tableb
ON tablea.columnx = tableb.columnx
WHERE (tablea.column1 = 'someString') AND (tablea.column2 = someNumber)

	library(tidyverse)

	#### Changing the values in a character/numeric vector ####

	# Create sample data frame
	df <- data.frame(
	col1 = c("A", "A", "A", "A", "B", "B", "B", "B"),
	col2 = c("C", "C", "D", "D", "C", "C", "D", "D"),
	col3 = c("E", "F", "E", "F", "E", "F", "E", "F"),
	stringsAsFactors = FALSE