https://github.com/allisonhorst/esm244-w2020-lab10
Science Score: 13.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
○CITATION.cff file
-
✓codemeta.json file
Found codemeta.json file -
○.zenodo.json file
-
○DOI references
-
○Academic publication links
-
○Academic email domains
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (7.3%) to scientific vocabulary
Repository
Basic Info
- Host: GitHub
- Owner: allisonhorst
- Language: HTML
- Default Branch: master
- Size: 8.75 MB
Statistics
- Stars: 1
- Watchers: 3
- Forks: 16
- Open Issues: 0
- Releases: 0
Metadata Files
README.md
ESM 244 - Lab 10
SQL and Python in R Markdown
The goal of this lab is to demo some ways to work with other languages (SQL, Python) within the R Studio IDE we've grown to know and love.
Together, we will:
- Explore and query a relational database with SQL in R Markdown using the
RSQLitepackage - Work with and update databases using SQL
- Talk through a Python-in-RMarkdown demo using
reticulate
You should:
- Install
RSQLitepackage by Kirill Müller et al. in R: "RSQLiteembeds the 'SQLite' database engine in R and provides an interface compliant with the 'DBI' package. The source for the 'SQLite' engine is included."
install.packages("RSQLite")
WARNING: potential unnecessary frustration below.
(...but do this if you're interested in interfacing between R and Python.)
Allison will also demo how to run some Python code in R Markdown using reticulate.
IF you want to actually do the Python part now or later (not required - I'll just demo this part), you can follow along here to get set-up. I installed Anaconda to get Python 3.7, & set my pathway to that version. This can be kind of a challenging set-up/installation/pathway battle, but once you get it running it's user-friendly through R Markdown.
Owner
- Name: Allison Horst
- Login: allisonhorst
- Kind: user
- Company: Observable
- Website: https://www.allisonhorst.com/
- Twitter: allison_horst
- Repositories: 183
- Profile: https://github.com/allisonhorst
Teaching | Data Science | Art | Science Communication
GitHub Events
Total
Last Year
Issues and Pull Requests
Last synced: over 1 year ago
All Time
- Total issues: 0
- Total pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Total issue authors: 0
- Total pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 0
- Pull requests: 0
- Average time to close issues: N/A
- Average time to close pull requests: N/A
- Issue authors: 0
- Pull request authors: 0
- Average comments per issue: 0
- Average comments per pull request: 0
- Merged pull requests: 0
- Bot issues: 0
- Bot pull requests: 0