Open Access Week 2023 - Community over Commercialization: Open Access Week Events

In celebration of Open Access Week 2023, Columbia University Libraries will host the following events:

Data Manipulation using Columbia’s Academic Commons API & OpenRefine

Tuesday October 17, 2023 from 2:00 - 4:00pm EST (Butler Library Room 208B)

You don’t have to know how to use the command line to effectively use data from APIs! Join staff from the Digital Scholarship unit and explore data harvesting and manipulation using the API of Columbia’s institutional repository, Academic Commons, and OpenRefine. In the first half session (2-3pm), attendees will receive a brief overview of repositories, learn general strategies for how to leverage open APIs to answer scholarly questions. And in the second half session (3-4pm), attendees will get an introduction to working with JSON files in OpenRefine. 

This workshop is beginner-friendly; attendees should be comfortable using spreadsheet programs, such as Microsoft Excel, Google Sheets, etc.

Please download and install OpenRefine prior to the workshop, or come a few minutes early if you have problems with installation.

There is a parallel session for R/Python users in another week (Oct. 24). Even if you are not interested in data manipulation, you are very welcome to join us in either week during 2-3pm and get to know Columbia’s open access academic repository (Academic Commons)!

Data Manipulation using Columbia’s Academic Commons API & R/Python

Tuesday October 24, 2023 from 2:00 - 4:00pm EST (Butler Library Room 208B)

If you are interested in using R or Python for open API data scraping, please join staff from the Digital Scholarship unit and explore data harvesting and manipulation using the API of Columbia’s institutional repository, Academic Commons. Attendees will receive a brief overview of repositories, learn general strategies for how to leverage open APIs to answer scholarly questions in the first hour, then get an introduction to working with JSON files in R or Python (depending on your personal choice) in the second hour. 

This workshop is beginner-friendly; attendees should know how to install and open R/Python before coming to the workshop.

If you prefer to use R in the workshop, please download and install R & RStudio prior to the workshop. If you prefer to use Python in the workshop, we will use Google Colab (so if you have a google account, you are all set!)

There is a parallel session for OpenRefine users in another week (Oct. 17). Even if you are not interested in data manipulation & coding, you are very welcome to join us in either week during 2-3pm and get to know Columbia’s open access academic repository (Academic Commons)!

How to Publish Open Access without Article Processing Charges (APCs)

Thursday October 26, 2023 from 12:00 - 1:00pm EST (Online)

Have you ever wanted to publish your work Open Access (OA) but didn’t have the funds to pay the associated Article Processing Charges (APCs)? Come to a workshop led by the Columbia University Libraries to find out how you can publish OA for free!

In this workshop, we’ll go over the basics of OA publishing. You will learn about the many forms of OA as well as how to:

• Utilize Columbia’s OA publishing agreements
• Publish in one of the Columbia University Libraries journals
• Find respected OA journals in your field
• Deposit your work in Columbia University’s Academic Commons

This workshop is geared towards graduate students, postdocs, and faculty but all are welcome.

International Open Access Week Event Directory - find free events hosted all over the world in celebration of Open Access Week.