Archival Research:
- Zachary Schrag's Quirky Workflow
- Catalogue Data Basics in the UK National Archives
- Becoming a Desk(top) Profession: Digital Photography and the Changing Landscape of Archival Research
Coding Languages I use everyday:
- Python3
- SQL (specifically SQlite)
Programs:
- Atom Editor (this is where I write python scripts and even plain text research notes)
- DB Browser for SQLite (program where I can work w GUI to view tables, edit cells, etc w/o always using the command line) Both of these programs are completely free and open source
Codecademy: I learned a lot of the basic syntax for both Python and SQL here from Codecademy. The intro to SQL is available without a subscription. Currently the basic Python2 course is free but Python3 requires a subscription. If you want you can do a free trial or start with Python2 (just keep in mind it's an earlier version and that there have been some changes), but you can also get started right away with some of these other tutorials and resources below.
Getting Started:
- Designing Databases for Historical Research
- Installing Python
- Practical programming for total beginners (possibly my favorite resource)
- Managing Research Data
Python Tutorials and Handy References:
- Python for beginners: String manipulation basics
- The Programming Historian: String manipulation in Python (The Programming Historian is excellent for humanities folks in general)
- Python List Tutorial: Lists, Loops, and More
- Python Dictionary Tutorial: Analyze Craft Beer with Dictionaries
Working with Data:
- Python SQLite3 tutorial (Database programming)
- SQLite Python: Creating a New Database- Using Python with SQLite (uses Python2 instead of Python3)
- SQLite Query Planner
- Working with CSV files: Excel vs Python
- The Programming Historian: Cleaning Data with OpenRefine
- Data Carpentry: Data Management with SQL for Social Scientists
- sub section specifically on using DB Browser for SQLite
- Joins in SQLite
Webscraping with BeautifulSoup4
- Library Carpentry: Introduction to webscraping
- The Programming Historian: Intro to Beautiful Soup anf Webscraping
- Scrape Wikipedia with Python
- Python Web Scraping Using BeautifulSoup
Additional Resources I need to categorize still:
- http:https://thiagomarzagao.com/2013/11/12/webscraping-with-selenium-part-1/
- https://srome.github.io/Parsing-HTML-Tables-in-Python-with-BeautifulSoup-and-pandas/
- https://medium.com/analytics-vidhya/programming-with-databases-in-python-using-sqlite-4cecbef51ab9
- https://datacarpentry.org/python-ecology-lesson/09-working-with-sql/index.html
- https://www.dataquest.io/blog/python-excel-xlwings-tutorial/
- https://www.dataquest.io/blog/python-api-tutorial/
- https://www.dataquest.io/blog/jupyter-notebook-tutorial/
- https://www.dataquest.io/blog/jupyter-notebook-tips-tricks-shortcuts/
- http:https://ds.lib.ucdavis.edu/2017/09/26/five-reasons-for-historians-to-learn-r/
- https://www.dataquest.io/blog/sql-fundamentals/
- http:https://blog.juliusschulz.de/blog/ultimate-ipython-notebook