Tag Archives: data

Python save csv to folder

In Python (pandas), saving a .csv file to a particular folder is not that hard, but then it may be confusing to beginners. The packages we need to import are: import pandas as pd import os.path Say, your folder name … Continue reading

Posted in Uncategorized | Tagged , , , | 1 Comment

Recall & Precision vs Sensitivity & Specificity

Other than accuracy rate, there are various metrics for machine learning to measure how “accurate” the model is. Some popular ones for binary classification are sensitivity (true positive rate) and specificity (true negative rate). In computer science, recall and precision … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Advanced Excel Date Editing and Formatting

Suppose you have an Excel file with dates in the format DD/MM/YYYY. So you have entries like 02/03/1999 (2 March 1999). Suppose you want to change it to 2/3/1999, i.e. remove leading zeroes from one digit days and months. It … Continue reading

Posted in Uncategorized | Tagged , | 1 Comment

Making big data a little smaller

While this result is nice, it also seems to mean that theoretically, we have already reached the limit in dimensional reduction for data compression. Source: Science Daily Harvard computer scientist demonstrates 30-year-old theorem still best to reduce data and speed … Continue reading

Posted in math | Tagged , | 1 Comment