This workshop will be offered on-line over Zoom. All registered participants will recieve a Zoom link after registrations close, typically 24 hours prior to the start of the workshop. 

NOTE: Please register for this workshop using your UC or other university email address, if you have one.  

Data obtained from the web or other outside sources is often messy and difficult to manage.  Pandas, a popular tabular data frame library in Python, and SQL, a structured query language for databases, provide two different but effective tools for getting a better handle on your data.  This workshop is designed to introduce you to both tools in the context of managing research data, demonstrate the strengths of each approach, and review how the two approaches can be particularly effective when used in combination.  

For more information, please see the course web page at:

https://courses.ucsf.edu/course/view.php?id=5203

Prerequisites:

This workshop will involve lots of hands on coding wtih SQL and Python. To follow along with the coding exercises, you should be familiar with core Python, at the level covered in Intro to Python Part 1 and Intro to Python Part 2, and basic SQL commands at the level covered in Intro to SQL. If you haven't enrolled in these introductory workshops, you can access the coursework and self-study options on the main DSI Programming web page at:

https://courses.ucsf.edu/course/index.php?categoryid=930

Digital Humanities Sequence

This sequence is designed for people with no prior programming experience. The workshops start with core python and sql before moving into more advanced or specialized topics in digital humanities, with an emphasis on text analysis and machine learning. 

You are welcome to take any of these workshops without attending the entire series. No formal pre-reqs are enforced, but if you are new to Python or SQL, you’ll get the core programming skills necessary for the later workshops by attending Intro to Python Part 1 and Part 2 along with Intro to SQL. 

Registration Links: 

• Intro to Python Part 1:
  • https://calendars.library.ucsf.edu/event/11946795
• Intro to Python Part 2:
  • https://calendars.library.ucsf.edu/event/11946839
• Intro to SQL:
  • https://calendars.library.ucsf.edu/event/11946900
• Data Analysis with Python, Pandas, and SQL:
  • https://calendars.library.ucsf.edu/event/11947263
• Intro to Unix:
  • https://calendars.library.ucsf.edu/event/11947161
• Reading Data from APIs with Python, Pandas, and SQL:
  • https://calendars.library.ucsf.edu/event/11947321
• Machine Learning with Python and Scikit-Learn:
  • https://calendars.library.ucsf.edu/event/11947452
• Python Background for Text Analysis and Natural Language Processing:
  • https://calendars.library.ucsf.edu/event/11947471
• Machine Learning for Document Classification and Sentiment Analysis:
  • https://calendars.library.ucsf.edu/event/11947489
• Google Cloud Tools, BiqQuery, and VertexAI:
  • https://calendars.library.ucsf.edu/event/11947492