Introduction

In this notebook, we are reverse engineering a story. Replace this text with the story you are replicating, with links to the story and the data you are going to use.

Load and Cleaning Data

In this block of text, include a data dictionary for the data you will use. You can create a table in markdown using this pattern:

column name column type description notes
first_col first_type description of first notes for first

Loading data

Be sure that anyone who takes this notebook will be able to load the data. Either load it directly from the source using a URL, or upload it to your R Studio Cloud project.

# Load required data.

Checking data

Make sure to check to be sure you understand whatโ€™s in it. Things to check for are:

  • Duplicate records
  • Missing information
  • Upper / lower case for filtering
  • How multiple tables fit together (if applicable)

For each code chunk, replace all of this text with a preface showing what your are checking for, and an explanation of what you found.

Sentences to Engineer

In this notebook, we are reverse engineering three sentences from the story

Sentence 1

  • Sentence text: [Paste in sentence to engineer here]

  • Analysis summary: [Write up two to three sentences describing the results of your analysis. Were you able to confirm the finding? If not, why not?]

# Put code to reverse engineer sentence here
# Display results of code below this codeblock

Sentence 2

  • Sentence text: [Paste in sentence to engineer here]

  • Analysis summary: [Write up two to three sentences describing the results of your analysis. Were you able to confirm the finding? If not, why not?]

# Put code to reverse engineer sentence here
# Display results of code below this codeblock

Sentence 3

  • Sentence text: [Paste in sentence to engineer here]

  • Analysis summary: [Write up two to three sentences describing the results of your analysis. Were you able to confirm the finding? If not, why not?]

# Put code to reverse engineer sentence here
# Display results of code below this codeblock
LS0tCnRpdGxlOiAiRGF0YSBBbmFseXNpcyAwMSBUZW1wbGF0ZSIKYXV0aG9yOiAiWW91ciBuYW1lIGhlcmUiCm91dHB1dDoKICBodG1sX2RvY3VtZW50OgogICAgdGhlbWU6IGNlcnVsZWFuCiAgICBoaWdobGlnaHQ6IHB5Z21lbnRzCiAgICB0b2M6IHRydWUKICAgIHRvY19mbG9hdDoKICAgICAgY29sbGFwc2VkOiB0cnVlCiAgICAgIHNtb290aF9zY3JvbGw6IGZhbHNlCiAgICBjb2RlX2Rvd25sb2FkOiB0cnVlCiAgICBjb2RlX2ZvbGRpbmc6IHNob3cKLS0tCgpgYGB7ciBzZXR1cCwgaW5jbHVkZT1GQUxTRX0KCmtuaXRyOjpvcHRzX2NodW5rJHNldChlY2hvID0gVFJVRSkKCmxpYnJhcnkodGlkeXZlcnNlKQpsaWJyYXJ5KGx1YnJpZGF0ZSkKbGlicmFyeShqYW5pdG9yKQoKIyBhZGQgb3RoZXIgbGlicmFyaWVzIGhlcmUKCgoKYGBgCgojIyBJbnRyb2R1Y3Rpb24gCgpJbiB0aGlzIG5vdGVib29rLCB3ZSBhcmUgcmV2ZXJzZSBlbmdpbmVlcmluZyBhIHN0b3J5LiBSZXBsYWNlIHRoaXMgdGV4dCB3aXRoIHRoZSBzdG9yeSB5b3UgYXJlIHJlcGxpY2F0aW5nLCB3aXRoIGxpbmtzIHRvIHRoZSBzdG9yeSBhbmQgdGhlIGRhdGEgeW91IGFyZSBnb2luZyB0byB1c2UuIAoKCiMjIExvYWQgYW5kIENsZWFuaW5nIERhdGEKCkluIHRoaXMgYmxvY2sgb2YgdGV4dCwgaW5jbHVkZSBhIGRhdGEgZGljdGlvbmFyeSBmb3IgdGhlIGRhdGEgeW91IHdpbGwgdXNlLiBZb3UgY2FuIGNyZWF0ZSBhIHRhYmxlIGluIG1hcmtkb3duIHVzaW5nIHRoaXMgcGF0dGVybjogCgp8IGNvbHVtbiBuYW1lIHwgY29sdW1uIHR5cGUgfCBkZXNjcmlwdGlvbiB8IG5vdGVzCnwgLS0tLS0tLS0tLS0tIHwgLS0tLS0tLS0tLXwgLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tfC0tLS0tLS0tLS0tLS0tLS0tfAp8IGZpcnN0X2NvbCB8IGZpcnN0X3R5cGUgfCBkZXNjcmlwdGlvbiBvZiBmaXJzdCB8IG5vdGVzIGZvciBmaXJzdCB8CgoKCiMjIyBMb2FkaW5nIGRhdGEKCkJlIHN1cmUgdGhhdCBhbnlvbmUgd2hvIHRha2VzIHRoaXMgbm90ZWJvb2sgd2lsbCBiZSBhYmxlIHRvIGxvYWQgdGhlIGRhdGEuIEVpdGhlciBsb2FkIGl0IGRpcmVjdGx5IGZyb20gdGhlIHNvdXJjZSB1c2luZyBhIFVSTCwgb3IgdXBsb2FkIGl0IHRvIHlvdXIgUiBTdHVkaW8gQ2xvdWQgcHJvamVjdC4gCgpgYGB7cn0KIyBMb2FkIHJlcXVpcmVkIGRhdGEuIAoKCmBgYAoKCiMjIyBDaGVja2luZyBkYXRhCgpNYWtlIHN1cmUgdG8gY2hlY2sgdG8gYmUgc3VyZSB5b3UgdW5kZXJzdGFuZCB3aGF0J3MgaW4gaXQuIFRoaW5ncyB0byBjaGVjayBmb3IgYXJlOiAKCiogRHVwbGljYXRlIHJlY29yZHMKKiBNaXNzaW5nIGluZm9ybWF0aW9uIAoqIFVwcGVyIC8gbG93ZXIgY2FzZSBmb3IgZmlsdGVyaW5nCiogSG93IG11bHRpcGxlIHRhYmxlcyBmaXQgdG9nZXRoZXIgKGlmIGFwcGxpY2FibGUpCgoKRm9yIGVhY2ggY29kZSBjaHVuaywgcmVwbGFjZSBhbGwgb2YgdGhpcyB0ZXh0IHdpdGggYSBwcmVmYWNlIHNob3dpbmcgd2hhdCB5b3VyIGFyZSBjaGVja2luZyBmb3IsIGFuZCBhbiBleHBsYW5hdGlvbiBvZiB3aGF0IHlvdSBmb3VuZC4gCgoKIyMgU2VudGVuY2VzIHRvIEVuZ2luZWVyCgpJbiB0aGlzIG5vdGVib29rLCB3ZSBhcmUgcmV2ZXJzZSBlbmdpbmVlcmluZyB0aHJlZSBzZW50ZW5jZXMgZnJvbSB0aGUgc3RvcnkKCiMjIyBTZW50ZW5jZSAxCgoqICoqU2VudGVuY2UgdGV4dCoqOiBbUGFzdGUgaW4gc2VudGVuY2UgdG8gZW5naW5lZXIgaGVyZV0KCgoqICoqQW5hbHlzaXMgc3VtbWFyeSoqOiBbV3JpdGUgdXAgdHdvIHRvIHRocmVlIHNlbnRlbmNlcyBkZXNjcmliaW5nIHRoZSByZXN1bHRzIG9mIHlvdXIgYW5hbHlzaXMuICBXZXJlIHlvdSBhYmxlIHRvIGNvbmZpcm0gdGhlIGZpbmRpbmc/IElmIG5vdCwgd2h5IG5vdD9dCgoKCmBgYHtyfQoKIyBQdXQgY29kZSB0byByZXZlcnNlIGVuZ2luZWVyIHNlbnRlbmNlIGhlcmUKIyBEaXNwbGF5IHJlc3VsdHMgb2YgY29kZSBiZWxvdyB0aGlzIGNvZGVibG9jawoKCgpgYGAKCiMjIyBTZW50ZW5jZSAyCgoqICoqU2VudGVuY2UgdGV4dCoqOiBbUGFzdGUgaW4gc2VudGVuY2UgdG8gZW5naW5lZXIgaGVyZV0KCiogKipBbmFseXNpcyBzdW1tYXJ5Kio6IFtXcml0ZSB1cCB0d28gdG8gdGhyZWUgc2VudGVuY2VzIGRlc2NyaWJpbmcgdGhlIHJlc3VsdHMgb2YgeW91ciBhbmFseXNpcy4gIFdlcmUgeW91IGFibGUgdG8gY29uZmlybSB0aGUgZmluZGluZz8gSWYgbm90LCB3aHkgbm90P10KCmBgYHtyfQoKCiMgUHV0IGNvZGUgdG8gcmV2ZXJzZSBlbmdpbmVlciBzZW50ZW5jZSBoZXJlCiMgRGlzcGxheSByZXN1bHRzIG9mIGNvZGUgYmVsb3cgdGhpcyBjb2RlYmxvY2sKCgpgYGAKCiMjIyBTZW50ZW5jZSAzCgoqICoqU2VudGVuY2UgdGV4dCoqOiBbUGFzdGUgaW4gc2VudGVuY2UgdG8gZW5naW5lZXIgaGVyZV0KCiogKipBbmFseXNpcyBzdW1tYXJ5Kio6IFtXcml0ZSB1cCB0d28gdG8gdGhyZWUgc2VudGVuY2VzIGRlc2NyaWJpbmcgdGhlIHJlc3VsdHMgb2YgeW91ciBhbmFseXNpcy4gIFdlcmUgeW91IGFibGUgdG8gY29uZmlybSB0aGUgZmluZGluZz8gSWYgbm90LCB3aHkgbm90P10KCmBgYHtyfQoKCiMgUHV0IGNvZGUgdG8gcmV2ZXJzZSBlbmdpbmVlciBzZW50ZW5jZSBoZXJlCiMgRGlzcGxheSByZXN1bHRzIG9mIGNvZGUgYmVsb3cgdGhpcyBjb2RlYmxvY2sKCgpgYGAKCg==