Data

Tools

Indexes

Applications

Experiments

Open Sustainable Technology

OpenRefine-ecology

Data Cleaning with OpenRefine for Ecologists.
https://github.com/datacarpentry/OpenRefine-ecology-lesson

Category: Sustainable Development
Sub Category: Education

Keywords

carpentries data-carpentry data-cleaning data-management ecology english lesson open-educational-resources openrefine stable

Keywords from Contributors

spreadsheet data-wrangling workshop carpentries-incubator puerto-rico beta fair-principles sustainable-software tibfds carpentries-lab

Last synced: about 18 hours ago
JSON representation

Repository metadata

Data Cleaning with OpenRefine for Ecologists

README.md

Create a Slack Account with us
Slack Status
DOI

OpenRefine-ecology

Data Cleaning with OpenRefine for Ecologists Lesson for Data Carpentry

OpenRefine Version

The current version has been tested with OpenRefine 3.7.2 on May 2023.

Data set notes

  • This data set is derived from The Portal Project Long-term desert ecology project data. This data file was downloaded and then modified specifically for use with OpenRefine.
    • Taxon names were put back into the file.
    • The number of rows was reduced to simplify the reconciliation and URL parsing exercises.
    • These modifications were made in order to illustrate some features of Open Refine.
      • Errors were added to the taxon names (scientificName field), to demonstrate OpenRefine's ability to find likely mis-entered data.
      • These errors can be found using clustering algorithms on the scientificName column, showing the power of the algorithms to find discrepancies quickly and making it simple to fix all issues found.

Contributing

We welcome all contributions to improve the lesson! Maintainers will do their best to help you if you have any questions, concerns, or experience any difficulties along the way.
We'd like to ask you to familiarize yourself with our Contribution Guide.

Please see the current list of issues for ideas for contributing to this repository. For making your contribution, we use the GitHub flow, which is nicely explained in the chapter Contributing to a Project in Pro Git by Scott Chacon.

Look for the tag good_first_issue. This indicates that the maintainers will welcome a pull request fixing this issue.

Maintainers

Current Maintainers

Past Authors and Maintainers

  • Abigail Cabunoc
  • Aleksandra Nenadic
  • April M. Wright
  • Betty Rozum
  • Bill Mills
  • Brian Yandell
  • C. Titus Brown
  • Cam Macdonell
  • Dan Mazur
  • Debbie Paul
  • Erin Becker
  • Francois Michonneau
  • Gabriel A. Devenyi
  • Greg Wilson
  • Hilmar Lapp
  • Hugo Tavares
  • Ian Carroll
  • James Allen
  • James Mickley
  • Jeffrey W. Hollister
  • Jon Pipitone
  • Jonah Duckles
  • Kari L. Jordan
  • Lisa Zilinski
  • Maxim Belkin
  • Michael Hansen
  • Nick Young
  • Piotr Banaszkiewicz
  • Raniere Silva
  • Ross Dickson
  • Ryan E. Johnson
  • Rémi Emonet
  • Timothée Poisot
  • Tracy Teal
  • W. Trevor King
  • Zack Brym
  • dlstrong
  • evanwill
  • trelogan

See the Authors page for details.

Citation (CITATION)

Please cite as:

Deborah Paul and Cam Macdonell (eds): "Data Carpentry: Data Cleaning with OpenRefine Ecology lesson."
Version 2017.04.0, April 2017,
http://www.datacarpentry.org/OpenRefine-ecology-lesson/,
FIXME: Add Zenodo DOI.

Owner metadata

GitHub Events

Total
Last Year

Committers metadata

Last synced: 1 day ago

Total Commits: 412
Total Committers: 66
Avg Commits per committer: 6.242
Development Distribution Score (DDS): 0.706

Commits in past year: 7
Committers in past year: 3
Avg Commits per committer in past year: 2.333
Development Distribution Score (DDS) in past year: 0.286

Name Email Commits
Luis J. Villanueva v****l@s****u 121
Erin Becker e****r@g****m 104
Debbie Paul d****l@f****u 23
Tracy Teal t****t@i****g 20
Francois Michonneau f****u@g****m 16
maneesha sane a****m@g****m 10
zkamvar z****r 10
Dorothea Salo 2****o 7
Brian Yandell b****l@b****t 6
Paul R. Pival p****l@u****a 6
Kari L. Jordan k****n@m****m 5
JoshuaDull j****l@g****m 4
Jeanine Finn j****n@u****u 4
Dan Mazur Q****n 4
Anelda van der Walt a****a 3
David LeBauer d****r@g****m 3
Kari L. Jordan k****n@c****g 3
Nicola Soranzo n****o@g****m 3
marijane white m****e 3
kdmclean 3****n 2
carmi cronje c****e 2
Trevor Keller t****r@n****v 2
Toby Hodges t****s@g****m 2
Ross Dickson r****n@d****a 2
Jeffrey W. Hollister j****r@g****m 2
C. Titus Brown t****s@i****g 2
Ben Companjen b****n@c****e 2
Aleksandra Nenadic a****c@m****k 2
Phillip Doehle d****e@o****u 2
Alex Robillard 5****A 1
and 36 more...

Committer domains:

Issue and Pull Request metadata

Last synced: 1 day ago

Total issues: 76
Total pull requests: 63
Average time to close issues: about 3 years
Average time to close pull requests: 6 months
Total issue authors: 42
Total pull request authors: 28
Average comments per issue: 2.2
Average comments per pull request: 0.98
Merged pull request: 49
Bot issues: 0
Bot pull requests: 0

Past year issues: 1
Past year pull requests: 17
Past year average time to close issues: N/A
Past year average time to close pull requests: 1 day
Past year issue authors: 1
Past year pull request authors: 5
Past year average comments per issue: 0.0
Past year average comments per pull request: 1.29
Past year merged pull request: 8
Past year bot issues: 0
Past year bot pull requests: 0

More stats: https://issues.ecosyste.ms/repositories/lookup?url=https://github.com/datacarpentry/OpenRefine-ecology-lesson

Top Issue Authors

  • ErinBecker (11)
  • maneesha (10)
  • tracykteal (8)
  • villanueval (5)
  • cmacdonell (2)
  • anenadic (2)
  • tobyhodges (2)
  • cengel (2)
  • jifar (1)
  • nmwolf (1)
  • debpaul (1)
  • kta65 (1)
  • bscheffler (1)
  • MikeTrizna (1)
  • mkweskin (1)

Top Pull Request Authors

  • villanueval (11)
  • carpentries-bot (9)
  • jas58 (5)
  • marijane (5)
  • tajuakins (4)
  • maneesha (4)
  • tobyhodges (3)
  • ppival (2)
  • Stonepeople (1)
  • sstevens2 (1)
  • kdmclean (1)
  • jellenf (1)
  • lyndamk (1)
  • jwscutt (1)
  • aprovoNYU (1)

Top Issue Labels

  • type:enhancement (22)
  • type:clarification (16)
  • good first issue (6)
  • type:template and tools (3)
  • help wanted (3)
  • status:in progress (2)
  • type:instructor guide (1)
  • status:refer to cac (1)
  • openrefine-3.5.0 (1)
  • type:formatting (1)
  • type:discussion (1)
  • openrefine-3.4.1 (1)

Top Pull Request Labels

  • type: template and tools (9)
  • type:enhancement (2)
  • status:in progress (2)
  • type:template and tools (1)
  • status:waiting for response (1)
  • type:clarification (1)

Dependencies

.github/workflows/pr-close-signal.yaml actions
  • actions/upload-artifact v3 composite
.github/workflows/pr-comment.yaml actions
  • actions/checkout v3 composite
  • carpentries/actions/check-valid-pr main composite
  • carpentries/actions/comment-diff main composite
  • carpentries/actions/download-workflow-artifact main composite
.github/workflows/pr-post-remove-branch.yaml actions
  • carpentries/actions/download-workflow-artifact main composite
  • carpentries/actions/remove-branch main composite
.github/workflows/pr-preflight.yaml actions
  • carpentries/actions/check-valid-pr main composite
  • carpentries/actions/comment-diff main composite
.github/workflows/pr-receive.yaml actions
  • actions/checkout v3 composite
  • actions/upload-artifact v3 composite
  • carpentries/actions/check-valid-pr main composite
  • carpentries/actions/setup-lesson-deps main composite
  • carpentries/actions/setup-sandpaper main composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/sandpaper-main.yaml actions
  • actions/checkout v3 composite
  • carpentries/actions/setup-lesson-deps main composite
  • carpentries/actions/setup-sandpaper main composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/update-cache.yaml actions
  • actions/checkout v3 composite
  • carpentries/actions/check-valid-credentials main composite
  • carpentries/actions/update-lockfile main composite
  • carpentries/create-pull-request main composite
  • r-lib/actions/setup-r v2 composite
.github/workflows/update-workflows.yaml actions
  • actions/checkout v3 composite
  • carpentries/actions/check-valid-credentials main composite
  • carpentries/actions/update-workflows main composite
  • carpentries/create-pull-request main composite

Score: 7.973844375944687