Get the big picture, determine scope, define success, find resources Big picture: know daily SQL queries, how to use them, what are the tricks and how to optimize them. Scope: 80% most freqent SQL usage. Success: Finish the online quiz on Hackerrank on SQL. Resources: SQL in 10 Minutes, Sams Teach Yourself (4th Edition) by Ben Forta
Get started Database vs. Table vs. Column: Container vs. structured file for some specific character vs.
As a graduating student in Data Science without much experience in that field, I want to write something for people with similiar background on how to review data science and get ready for interview. Here is my methodology adapted from the book Soft Skills: The Software Developer’s Life Manual.
Before we started, it is very important to know yourself in the data science field: what is your current stage, what kind of applicant you want to be, and what is your strength and weakness?
I started this blog last September, and I haven’t used it until this January. I began to write some articles this April regularly, so I was not entirely familiar with blogging, and it seems that no so many people know and visit this blog. Earlier today, when I tried to click on the tags under the article, I found that there is a bug corresponding it that it uses two backslashes instead of one.
In my recent project, there is a need to create some visualization for the relationship between bank accounts. One bank account could serve as an intermediate account to receive money from its child account, and transfer the surplus to its head account. I want to find out the relationship between accounts and do some further analysis, so I searched online to find some visualization tools for network analysis, and here are some tools I try.
3 Preliminary Analysis of Data Quality
3.1 Missing Patterns Analysis
3.2 Outlier Analysis
4 Executive Summary
5 Main Analysis
5.1 Analysis on Speaking Languages
5.2 Analysis on Ethnicity
5.3 Analysis on Body Type
6 Summary, Limitation and Further Direction
This exploratory data analysis firstly provides a preliminary analysis of the data quality of the Yahoo Dating dataset. An executive summary is followed to explain the most important findings in this study.
I received my Nintendo Labo 01: variety kit this afternoon, and I immediately went through it. There are three parts: Make, Play and Discover. You need to fold and formulate different items, like RC car, fishing rod, and piano. Each piece will take you a while to finish it. Larger and more complicated piece will take longer time: the toy-con piano will take up to 210 minutes to complete that, so you need to prepare for that.