Daily To-do Assignments

To-do #1

Due 1/21 (Th), 1pm

The Internet is full of published linguistic data sets. Let’s data-surf! Instructions:

1. Go out and find two linguistic data sets you like. One should be a corpus, the other should be some other format. They must be free and downloadable in full. Make sure they are linguistic data sets, meaning designed for linguistic inquiries.
2. You might want to start with various bookmark sites listed in the following Learning Resources sections: Linguistic Data, Open Access, Data Publishing and Corpus Linguistics. But don’t be constrained by them.
3. Download the data sets and poke around. Open up a file or two to take a peek. (No need to do this in Python: Save that for HW1.)
4. In a text file (should have the .txt extension), make note of:
   • The name of the data resource
   • The author(s)
   • The URL of the download page
   • Its makeup: size, type of language, format, etc.
   • License: whether it comes with one, and if so what kind?
   • Anything else noteworthy about the data. A sentence or two will do.
5. If you are comfortable with markdown, make an .md file instead of a text file.

SUBMISSION: Upload your text file to To-do1 submission link, on Canvas.

To-do #2

Due 1/28 (Th), 1pm

Learn about the numpy library: study the Python Data Science Handbook and/or the DataCamp tutorial. While doing so, create your own study notes, as a Jupyter Notebook file entitled numpy_notes_yourname.ipynb. Include examples, explanations, etc. Replicating DataCamp’s examples is also something you could do. You are essentially creating your own reference material.

SUBMISSION: Your file should be in the todo2/ directory of the Class-Exercise-Repo. Make sure it’s configured for the “upstream” remote and your fork is up-to-date. Push to your GitHub fork, and create a pull request for me.

To-do #3

Due 2/2 (Tue)

Study the pandas library (through the Python Data Science Handbook and/or the DataCamp tutorials). pandas is a big topic with lots to learn: aim for about 1/2. While doing so, try it out on TWO spreadsheet (.csv, .tsv, etc.) files:

1. The first file should be your choice. You can get one from this CSV Files archive, or make up your own. Keep it super simple! It’s supposed to be a toy dataset.
2. The second one should be billboard_lyrics_1964-2015.csv by Kaylin Pavlik, from her project ‘50 Years of Pop Music’. (Note: you might need to specify ISO8859 encoding.)

Name your Jupyter Notebook file pandas_notes_yourname.ipynb. Don’t change the filename of any downloaded CSV files or edit them in any way – important!

SUBMISSION: Your files should be in the todo3/ directory of Class-Exercise-Repo. Commit and push all three files to your GitHub fork, and create a pull request for me.

To-do #4

Due 2/4 (Thu)

This one is a continuation of To-do #3: work further on your pandas study notes. You may create a new JNB file, or you can expand the existing one. Also: try out a spreadsheet submitted by a classmate. You are welcome to view the classmate’s notebook to see what they did with it. (How to find out who submitted what? Git/GitHub history of course.) Give them a shout-out.

SUBMISSION: We’ll stick to the todo3/ directory in Class-Exercise-Repo. Push to your GitHub fork, and create a pull request for me.

To-do #5

Due 2/16 (Tue)

Let’s pool our questions together for Dr. Lauren Collister, who will be our guest speaker on Tuesday. Review the topics of linguistic data, open access, and data publishing, focusing in particular on these three resources: “Data Sharing for Linguists”, Kitzes (2018), and the “Copyright and Intellectual Property Toolkit”.

Think of a question or two on the topic, and add yours along with your name to this MS Word document posted on our MS Teams forum.

SUBMISSION: The shared MS Word document is your submission. Dr. Collister will take a look at your questions before class, so early submissions are appreciated!

To-do #6

Due 2/25 (Thu)

Let’s try Twitter mining! On a tiny scale that is. Step-by-step tutorials are posted in this Resources section, so pick one and follow along. Take a look at my in-class demo too.

Before beginning, you will need to install the tweepy library. This YouTube video demonstrates how to install it through Anaconda Navigator.

Notes on using tweepy:

• If you don’t have a Twitter account, you will have to create one first. And then, you should create an API account.
• This is exciting stuff, but don’t go overboard! 100 Tweets are enough for this exercise. Overloading API without taking proper cautionary steps is a sure-fire way to get yourself banned from tech sites.
• You will be using your ‘Consumer Key’ and ‘Consumer Secret’ in your code. You should not be sharing them! Right before committing, redact them in your JNB file by changing the string values to ‘XXXXXXXXXXXXXX’.

SUBMISSION: We will use Class-Exercise-Repo, the todo6/ folder. Your Jupyter Notebook file should have your name in the file name. Push to your fork and create a pull request. Make sure you have redacted your personal API keys!

To-do #7

Due 3/2 (Tue)

The Gries & Newman article cites many famous corpora and corpus resources. Let’s round them all up in a single spot, complete with web links. We will collaborate on a shared document called 'corpora_tools_list.md'.

• The Class-Lounge repo belongs to all of us: we are all listed as a collaborator.
• That means all of us has full read and write access: in GitHub’s lingo, we have ‘push access’.
• Which means no need to fork; you should directly clone. After that, push and pull directly.

Your job is to fill out the two tables: add at least one entry to each. Make sure you are not duplicating someone else’s entry. Because everyone is editing the same document, you may run into a conflict while trying to push. (Fingers crossed!) Make sure you have read and understood this tutorial on Git conflicts and resolve accordingly.

SUBMISSION: There is no formal submission process, because this one does not involve you issuing a pull request or anything like that. I will check on the repo later to see you have indeed made your contribution.

To-do #8

Due 3/9 (Tue)

Let’s try sentiment analysis on movie reviews. Follow this tutorial in your own Jupyter Notebook file. Feel free to explore and make changes as you see fit. If you haven’t already, review the Python Data Science Handbook chapters to give yourself a good grounding. Also: watch DataCamp tutorials Supervised Learning with scikit-learn, and NLP Fundamentals in Python.

Students who took LING 1330 (=everyone): compare sklearn’s Naive Bayes with NLTK’s treatment and include a blurb on your impression. (You don’t have to run NLTK’s code, unless you want to!)

SUBMISSION: Your jupyter notebook file should be in the todo8 folder of Class-Exercise-Repo. As usual, push to your fork and create a pull request.

To-do #9

Due 3/11 (Thu)

What have the previous students of LING 1340/2340 accomplished? What do finished projects look like? Let’s have you explore their past projects. Details:

• Pick from two previous years: 2020 spring, and 2019 spring.
• We’ll collaborate on a single file: todo9_past_project_critiques.md in our public repo Class-Lounge.
• Pick two projects, but you can’t pick one that already has 3 critiques. (If someone gets the last spot while you’re working, you’ll have to pick a new one. And: declaring “dips” is allowed, as long as you intend to finish the work within the next hour.)
• Create a section for yourself. Provide a link to the project repo.
• Your critique should consist of: one thing you thought was done well, one avenue for improvement, and one thing you learned.

SUBMISSION: Push your commit directly to the Class-Lounge repo. Make sure you don’t trample on someone else’s contribution. If there is a conflict, it is your job to resolve it.

To-do #10

Due 3/18 (Thu)

What has everyone been up to? Let’s take a look – it’s a “visit your classmates” day!

• First off, prepare your own “Guestbook” file. It’s already been created in the Class-Lounge repo, but you should edit it so that:
  • It has your project title and a link to your repo, and your name
  • And a bit of personalization if you want, like a greeting.
• Now visit your classmates’ projects! We will go by the order of first names, which can be found right in the directory. You should visit two people after you (Abby: Emily and Emma, Michael: Sonia and Abby, etc.)
• Take a look around, and write on their guestbook. (You don’t have to wait until it’s prepped.) Like the previous To-do, your entry should consist of: one thing you thought was done well, one avenue for improvement or suggestion, and one thing you learned.

SUBMISSION: Since Class-Lounge is a fully collaborative repo, there is no formal submission process.

To-do #11

Due 3/25 (Thu), free 1-day extension until Friday midnight (due to self-care day on Wed)

Let’s poke at big data. Well, big-ish – how about 8.6 million restaurant reviews? The Yelp DataSet Challenge has been going strong for 10+ years now, where Yelp make their huge review dataset available for academic groups that participate in a data mining competition. Challenge accepted! Before we begin:

• You will need a strong and stable internet connection and at least 16GB of free disk storage space.
• Provision enough time. Downloading the dataset alone may take 25 minutes or longer.

Mode of operation

• After downloading the data set, you should operate exclusively in a command-line environment, utilizing unix tools.
• I am supplying general instructions below, but you will have to fill in the blanks between steps, such as cd-ing into the right directory, invoking your Anaconda Python and finding the right file argument.

Step 1: Preparation, exploration

Let’s download this beast and poke around.

1. Download the JSON portion of the data. (We don’t need the photos.)
2. Move the downloaded archive file into your Documents/Data_Science directory. You might want to create a new folder there for the data files.
3. From this point on, operate exclusively in command line.
4. The file is in the .tar format. Look it up if you are not familiar. Untar it using tar -xvf. I will extract 5 json files along with a PDF document.
5. Using various unix commands (ls -laFh, head, tail, wc -l, etc.), find out: how big are the json files? What do the contents look like? How many reviews are there?
6. How many reviews use the word ‘horrible’? Find out through grep and wc -l. Take a look at the first few through head | less. Do they seem to have high or low stars?
7. How many reviews use the word ‘scrumptious’? Do they seem to have high stars this time?

Step 2: A stab at processing

How much processing can our own puny personal computer handle? Let’s find out.

1. First, take stock of your computer hardware: disk space, memory, processor, and how old it is.
2. Create a Python script file: process_reviews.py. Content below. You can use nano, or you could use your favorite editor (atom, notepad++) provided that you launch the application through command line.

import pandas as pd
import sys
from collections import Counter

filename = sys.argv[1]

df = pd.read_json(filename, lines=True, encoding='utf-8')
print(df.head(5))

wtoks = ' '.join(df['text']).split()
wfreq = Counter(wtoks)
print(wfreq.most_common(20))

1. We are NOT going to run this on the whole review.json file! Start small by creating a tiny version consisting of the first 10 lines, named FOO.json, using head and >.
2. Then, run process_reviews.py on FOO.json. Note that the json file should be supplied as command-line argument to the Python script, so your command will look something like below.
   • python process_reviews.py FOO.json
3. Confirm it ran successfully.
4. Next, re-create FOO.json with incrementally larger total # of lines and re-run the Python script. The point is to find out how much data your system can reasonably handle. Could that be 1,000 lines? 100,000?
5. While running this experiment, closely monitor the process on your machine. Windows users should use Task Manager, and Mac users should use Activity Monitor.
6. Finally, write up a short summary on this shared markdown file in Class-Lounge. A few sentences will do. How was your laptop’s handling of this data set? What sorts of resources would it take to successfully process it in its entirety and through more computationally demanding processes? Any other observations?

SUBMISSION: Your entry on this shared MD file. Make sure to properly resolve conflicts (if any)!

To-do #12

Due 3/30 (Tue)

Trying out CRC, with bigger data + better code!

Warm-up

• Following the H2P user guide, log into your CRC account.
• Try out the To-do #11 redux I demonstrated in class, using 1 million review data.

Take 1: Bigger data

• Let’s go bigger! Reprise the experiment using 4 million reviews this time.
• Files involved: review_4mil.json (newly created), process_reviews.py (same Python script), todo12.sh (new slurm script), todo12.out (newly generated output file).
• After the job is done, study the job stats via seff job-id command.

Take 2: Better code

• Let’s improve our Python code this time. Create a new script file process_reviews_eff.py with the following. The code produces the same results, but structured differently.

import pandas as pd
import sys
from collections import Counter

filename = sys.argv[1]

df_chunks = pd.read_json(filename, chunksize=10000, lines=True, encoding='utf-8')

wfreq = Counter()

for chunk in df_chunks:
    for text in chunk['text']:
        wfreq.update(text.split())

print(wfreq.most_common(20))

• Keep the data size the same: 4 million reviews.
• Edit todo12.sh to run this new script.
• After the job is done, study the job stats via seff job-id command. Night and day! What about this new Python code led to this much improvement in efficiency? Give it some thought, we’ll discuss in class.

Take 3: EVEN BIGGER data and better code (optional, but aren’t you curious?)

• Run the new, improved Python script on all of review data, which consists of 8.6 million reviews total.
• When the job is done, again check the stats. How long did it take to run, and how much RAM did the process use?

SUBMISSION: Your files on CRC are your submission. I have read access to them.

To-do #13

Due 4/1 (Thu)

Visit your classmates, round 2.

• First, maintain your own guestbook. Respond to your classmates’ visit logs.
  • No need to post a lengthy response – you are not starting a debate here! You can think of it as something akin to Facebook’s “like”, just a small acknowledgment or a thank you.
• Now visit your classmates’ projects, two of ‘em. Like before we go by the order of first names, which can be found right in the directory. You should visit two people after your previous visits.
  • Take a look around, and write on their guestbook. Like the previous visit, your entry should consist of: one thing you thought was done well, one avenue for improvement or suggestion, and one thing you learned.

SUBMISSION: Since Class-Lounge is a fully collaborative repo, there is no formal submission process.

To-do #14

Due 4/8 (Thu)

Another round of “visit your classmates”. You know what to do!

To-do #15

Due 4/15 (Thu)

4th and final round of “visit your classmates”, also the last To-do! Visit that one remaining classmate, plus re-visit one classmate of your choice.