I wrote this SQL code recently and wanted to share it here (in a modified form to simplify). This isn’t a “typical” SQL SELECT statement, because of how each row is checking the rest of the table relative to its own fiscal year value.
Category: resources
Data Visualization Project
You may have seen me tweeting about some research I did on “Data Visualization for Exploratory Data Analysis” for my Cognitive Systems Engineering course. My presentation went really well! I’m less satisfied with the paper since it was done in a hurry to complete the project deliverables, but i’m including it because it explains some… Continue reading Data Visualization Project
Data Sciencey Podcasts (Updated)
I’ve been listening to a lot of podcasts this semester since I am driving 1 hour each way to class twice a week, and I thought I’d share some good ones I’ve found. I started out by listening to the entire season of Serial (which I recommend!), then switched to fun and sciencey ones for… Continue reading Data Sciencey Podcasts (Updated)
A Couple Articles of Interest
Hi, there! I’ve been so busy with projects lately (for work, class, personal), that I haven’t been able to do as many data science learning projects as I’ve wanted to, but I have been reading up, and I wanted to share some articles I recently found interesting with you! The first is “Crushed It! Landing… Continue reading A Couple Articles of Interest
Girl Develop It! Meetup
In the past, I’ve been “semi-anonymous” on this blog, not advertising my real name or employment. However, if I’m going to start doing “appearances”, I might as well make it easy for people to match up my blog with my name! So hello, I’m Renee Marie Parilak Teate, and I’m becoming a data scientist :)… Continue reading Girl Develop It! Meetup
Data Science Practice – Classifying Heart Disease
This post details a casual exploratory project I did over a few days to teach myself more about classifiers. I downloaded the Heart Disease dataset from the UCI Machine Learning respository and thought of a few different ways to approach classifying the provided data. ——————————————- “MANUAL” APPROACH USING EXCEL So first I started out by… Continue reading Data Science Practice – Classifying Heart Disease
My “What is Data Science?” Talk
I got a chance to tell the undergraduate students at JMU about data science tonight! Despite the cold weather and short notice (the invites went out 2 days before), over 20 students showed up for the talk, which was hosted by the IEEE Computer Society club. The students’ majors included Integrated Science & Technology, Computer… Continue reading My “What is Data Science?” Talk
Doing Data Science (Review)
I just finished reading Doing Data Science: Straight Talk from the Frontline, an O’Reilly book by Cathy O’Neil (@mathbabedotorg) and Rachel Schutt (Columbia Data Science blog). First let me say, I really enjoyed this book! I thought it gave a great overview of Data Science, which is very valuable at this early stage in my… Continue reading Doing Data Science (Review)
Machine Learning Project 4
So immediately after I turned in project 3, I started on Project 4, our final project in Machine Learning grad class. We had a few options that the professor gave us, but could also propose our own. One of the options was learning how to implement Random Forest (an ensemble learning method using many decision trees) and analyzing a given data set, so I proposed using Random Forest on University Advancement (Development/Fundraising) data I got from my “day job”. The professor approved it, so I started learning about Random Forest Classification.
Wolfram Language
Stephen Wolfram recently announced that he is releasing a programming language that appears to include a quick development approach for mathematical and data science projects (and more), utilizing everything that Wolfram Alpha and Mathematica are capable of, and taking them to another level completely. The demonstration in the video is very impressive, and I’m excited to try this out!