Python Day 46 – more SQL

Today I continued working on SQL…

I learned:

To count up certain values or the number of variables in a column, one can use COUNT(*), and attach “AS new_category_name” to create a new category with the count! This was useful in the example data of Nobel laureates to count how many prizes each country won. It’s also important to use “GROUP BY category_name” to determine how to group the counted variable.

This feels like the first real step in data analysis. I can now take the data and view it in different ways which allows me to put in some creativity. Fun!

I am still confused on:

When importing a database with the fancy code my friend setup…

def db_connect(db_name):
conn = sqlite3.connect(db_name)
print(“Connection established”)
except Error:
print(Error, “Cannot create connection to database”)
return conn

conn = db_connect(“data/nobel.db”)

… I will sometimes get the error “local variable ‘conn’ referenced before assignment’. But this sometimes doesn’t happen and the code works properly. I’m not sure what’s the differentiating variable here… hmph.

Anywho progress is exciting! I’ve been in line to get this COVID test for the past 3 hours so it’s been nice to be productive coding 🙂

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: