Data Science for Agriculture

How to manage and manipulate data for agricultural research

Creative Commons License

Exercises

Access | Python | R | SQL

Access

Topic Title Output
Advanced Queries Joins 1
Advanced Queries Joins 2
Advanced Queries Joins 3
Advanced Queries Joins 4
Advanced Queries Nested Queries
Aggregation Count
Aggregation Sum
Basic Queries Filtering
Basic Queries Grouping 1
Basic Queries Grouping 2
Basic Queries Selecting
Basic Queries Sorting
Database Control Creating Tables
Database Control Importing Tables
Database Structure Redundancy
Database Structure Split Cells
Database Tools Forms 1
Database Tools Forms 2
Database Tools Forms 3
Database Tools Reports

[back to top]

Python

Topic Title Output
Basic Data Management Review
Basic List Review
Combining Basics Shrub Volume [txt]
Data Analysis Code Shuffle
Debugging Fix the Code 1
Dictionaries Species Composition 2
Expressions & Variables Basic Expressions [txt]
Expressions & Variables Basic Variables [txt]
Expressions & Variables Modify the Code 1 [txt]
Expressions & Variables More Variables [txt]
Expressions & Variables Variable Reassignment
For Loops Exponential Growth 1
For Loops Repeat Strings
For Loops While
Functions Built-in Functions [txt]
Functions for Loop
Functions GC Content 2 [txt]
Functions Nested Functions
Functions Use and Modify [txt]
Functions Writing Functions [txt]
Graphing Adult vs Newborn Size 1 [png] [png] [png]
Graphing Mammal Body Size 3 [png]
Graphing Mass vs Metabolism [png] [png]
Higher Order Functions DNA
Higher Order Functions Species Area Relationship 1
Inheritance Platypus 4
Libraries Species Area Relationship 2
List Comprehensions Platypus 5
Lists Bird Banding 1 [txt]
Lists Bird Banding 2
Lists Bird Banding 3
Lists DNA Complement 1
Lists DNA or RNA 2
Lists Loop
Lists Nested Lists 1
Lists Nested Lists 2
Lists Ultimate Question 2
Loops Improve Your Code [txt]
Loops Shrub Dimensions 1 [txt]
Loops Shrub Dimensions 2
Loops Shrub Dimensions 3
Making Choices Choice Operators [txt]
Making Choices DNA or RNA 1 [txt]
Making Choices GC Content 3
Making Choices Modify the Code 2 [txt]
Making Choices Unit Conversion Challenge
Modules math Functions [txt]
Object Oriented Programming Platypus 1
Object Oriented Programming Platypus 2
Object Oriented Programming Platypus 3
Problem Decomposition Exponential Growth 2
Regular Expressions List the Rodents 1
Regular Expressions List the Rodents 2
Scientific DNA Complement 2
Scientific Mammal Body Size 1 [txt]
Scientific Mammal Body Size 2 [txt]
Scientific Shrub Volume 2 [txt]
Scientific Size-biased Extinction 1
Scientific Size-biased Extinction 2
Scientific Tree Biomass
Sets Species Composition 1
Shell Bird Counts 1
Shell Bird Counts 2
Shell Executable Programs
Shell Finding Things
Shell Getting Started
Shell Pipes and Filters
Shell Server
Statistics Adult vs Newborn Size 2 [txt] [png]
Statistics Mammal Body Size 4 [txt]
Statistics Shrub Volume 3 [txt]
Strings GC Content 1 [txt]
Strings Long Strings [txt]
Strings Print Strings [txt]
Strings Split Strings [txt]
Strings string Functions [txt]
Strings string Methods [txt]
Strings Strings and Math
Strings Ultimate Question 1
Tests Fix the Code 2
Tests Refactor
Version Control Add and Revert Comment
Version Control Fix the Code
Version Control Merge Conflict
Version Control Predict Richness
Version Control Pull and Move
Version Control Revert
Version Control Richness Merge Conflict
Version Control Richness Revert
Version Control Set-up Git

[back to top]

R

Topic Title Output
Basic Data Management Review [txt] [txt]
Basic Vector Review [txt]
Combining Basics Shrub Volume 5 [txt]
Data Analysis Code Shuffle [jpeg]
QAQC Data entry validation in spreadsheets
Data Frames Specific Leaf Area 2 [txt]
Data Frames Database CSV [txt]
Data Frames Shrub Volume 2 [txt]
Debugging Fix the Code 2 [txt]
dplyr Fix the Code 1 [txt]
dplyr Link to Databases [txt]
Expressions & Variables Basic Expressions [txt]
Expressions & Variables Basic Variables [txt]
Expressions & Variables Modify the Code 1 [txt]
Expressions & Variables More Variables [txt]
Expressions & Variables Variable Reassignment [txt]
Functions Built-in Functions [txt]
Functions for Loop [txt]
Functions Nested Functions [txt]
Functions Strings from Data 2 [txt]
Functions Use and Modify [txt]
Functions Writing Functions [txt]
Good Style Modify the Code 3 [jpeg]
Graphing Adult vs Newborn Size 1 [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Mammal Body Size 3 [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Mass vs Metabolism [jpeg] [jpeg] [jpeg]
Higher Order Functions Species Area Relationship [txt]
Loops Improve Your Code [txt]
Loops Multiple Files [txt]
Loops stringr [txt]
Making Choices Choice Operators [txt]
Making Choices DNA or RNA [txt]
Making Choices Modify the Code 2 [txt]
Making Choices Unit Conversion Challenge [txt]
Modules dplyr
NEON NEON Database [jpeg] [jpeg] [jpeg]
NEON NEON Raster [jpeg]
R output Creating Publication-Quality Figures
Putting It All Together Size-biased Extinction [txt] [txt] [png]
Downloading SSURGO data with the soilDB package SSURGO data with soilDB [txt] [txt] [txt] [txt] [txt] [txt]
R Spatial Converting Raw Data to Spatial Data [txt] [txt] [txt] [jpeg]
R Spatial Importing Spatial Data [jpeg] [jpeg] [jpeg]
R Spatial Manipulating and Transforming Spatial Data [txt] [txt] [txt] [txt] [jpeg] [jpeg] [jpeg]
R-Markdown R Markdown Basics [jpg]
R-Markdown R Markdown Data Analysis [jpg]
R-Markdown R Markdown Figures [jpg] [jpg]
R-Markdown R Markdown References [jpg] [jpg] [jpg]
R-Markdown R Markdown Tables [jpg]
R Spatial Producing a Custom Map [jpeg] [jpeg] [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Downloading public data with the FedData package Using FedData [txt] [txt] [txt] [jpg]
R-SQL Automate Query [txt]
R-SQL Connect and Query [txt]
R-SQL Data Stream [txt]
R-SQL Export to Database [txt]
Regular Expressions Find the Rodents [txt]
Saving Figures Producing Documents with R
Scientific Mammal Body Size 1 [txt]
Scientific Mammal Body Size 2 [txt]
Scientific Shrub Volume 3 [txt]
Scientific Tree Biomass Challenge [txt]
SQL Practice Basic Queries Review
Statistics Adult vs Newborn Size 2 [txt] [jpeg] [jpeg]
Statistics Mammal Body Size 4 [txt]
Statistics Mixed Model Analysis [txt] [txt] [txt]
Statistics Shrub Volume 4 [txt]
Strings Built-in Functions [txt]
Strings Function with Choices [txt]
Strings Long Strings [txt]
Strings Print Strings [txt]
Strings Split Strings [txt]
Strings stringr Functions [txt]
Strings Strings and Math [txt]
Strings Strings from Data 1 [txt]
Tests Fix the Code 3 [txt]
Tidy Data Applying Tidy Data Principles
Tidy Data Messy Portal Data
Tidyr Tree Biomass [txt]
Vectors NDVI [txt]
Vectors Specific Leaf Area 1 [txt]
Vectors Bird Banding [txt]
Vectors Shrub Volume 1 [txt]
Version Control Add and Revert Comment
Version Control Basic Adding a Remote
Version Control Basic Commit Multiple Files
Version Control Basic First Commit
Version Control Basic Importing Data
Version Control Basic Pulling and Pushing
Version Control Basic Pushing Changes
Version Control Basic Set-up Git
Version Control Fix the Code
Version Control Git Set-up
Version Control Merge Conflict
Version Control Pull and Move
Version Control Revert

[back to top]

SQL

Topic Title Output
Advanced Queries JOIN 1 [txt]
Advanced Queries JOIN 2 [txt]
Advanced Queries JOIN 3 [txt]
Advanced Queries JOIN 4 [txt]
Advanced Queries Nesting Queries [txt]
Aggregation COUNT [txt]
Aggregation SUM [txt]
Basic Queries DISTINCT [txt]
Basic Queries GROUP BY [txt]
Basic Queries ORDER BY [txt]
Basic Queries SELECT [txt] [txt]
Basic Queries WHERE [txt] [txt] [txt]
Database Control Adding Records [txt]
Database Control Creating Tables [txt]
Database Control Importing Data [txt] [txt] [txt]
Database Control Missing Data [txt]
Database Control Updating Records [txt]
Database Structure Redundancy [txt] [txt] [txt]
Database Structure Split Cells [txt] [txt]
QAQC Data entry validation in Excel
Tidy Data Real Portal Data

[back to top]