#!/usr/bin/env python
# coding: utf-8

# # Religious Life in 1911 Charlotte, North Carolina
# ### Using OpenRefine and Tableau to Tell a Data Story

# * Contributor: Mia Steinle
# * Data source: https://archive.org/details/charlottenorthca1911pied
# * License: [Creative Commons - Attribute 4.0 Intl](https://creativecommons.org/licenses/by/4.0/)
# * Attribution: This work is based upon digital assignments completed by MLIS Students in INST742: Implementing Digital Curation

# ## 6. Religious Life in 1911 Charlotte, NC:
# * **Author:** Mia Steinle
# * **Abstract:** Identifying places of workshop using regular expressions in order to reveal places of worship by denomination and race with an emphasis on archival silences.
# * **Dataset:** Full datified Directory (16,000 entries), 1911 Sanborn map, 1910 Census
# * **Tools:** OpenRefine, Tableau
# * **Video:** https://youtu.be/uIbvZMRW_-I (11′ 10″)

# ***

# <h3> About this Exercise </h3>

# While on first glance the 1911 Charlotte, North Carolina, city directory is simply a listing of people and businesses, it contains many stories. I took a .csv file of the directory's 15,700 entries — which had been extracted from scanned images of the directory using OCR — to look for stories about places of worship in Charlotte. After cleaning up and transforming the data in OpenRefine, I used Tableau Public to visualize the data. This series of notebooks explains that process, presents my findings from the data, and suggest an avenue for further research and data analysis.
# 

# <h3> Computational Thinking </h3>
#     

# This exercise utlizes the following elements of computational thinking: 
# 
# |Category|Element|Example|
# |--------|-------|------|
# |Data practices |Creating data    |Generating data about religious denominations in OpenRefine |
# |Data practices |Manipulating data|Sorting, filtering, and cleaning data in OpenRefine |  
# |Data practices |Analyzing data   |Looking for patterns using Tableau |
# |Data practices |Visualizing data |Creating charts and graphs in Tableau |
# |Computational problem-solving practices |Computer programming |Using markdown language and code to build this Notebook |
# |Computational problem-solving practices |Troubleshooting and debugging |Determing the right GREL expressions to use in OpenRefine |

# <h3>Notebooks in this Series</h3>

# 1. [OpenRefine](OpenRefine.ipynb)
# 2. [Tableau](Tableau.ipynb)
# 3. [Next Steps](NextSteps.ipynb)