摘要:Almost all the developers use git every day. It is amazing to see how git became a de facto so quickly. Despite of using git such a long time, I see m 阅读全文
Python Tutorial: Model Evaluation & Selection
2019-09-01 22:05 by nuswgg, 227 阅读, 0 推荐, 收藏, 编辑
摘要:9.1 Evaluate the accuracy of regression models. a) Evaluation on training data. train = pd.read_csv('/Users/boston_train.csv')test = pd.read_csv('/Use 阅读全文
Python Tutorial: Forecasting
2019-09-01 22:04 by nuswgg, 464 阅读, 0 推荐, 收藏, 编辑
摘要:8.1 Fit an ARIMA model to a timeseries. a) Plot the timeseries. # Read in new data setair = pd.read_csv('/Users/air.csv')air["DATE"] = pd.to_datetime( 阅读全文
Python Tutorial: Supervised Machine Learning
2019-09-01 22:03 by nuswgg, 134 阅读, 0 推荐, 收藏, 编辑
摘要:6.1 Fit a logistic regression model on training data and assess against testing data. a) Fit a logistic regression model on training data. # Notice we 阅读全文
Python Tutorial: Unsupervised Machine Learning
2019-09-01 22:03 by nuswgg, 196 阅读, 0 推荐, 收藏, 编辑
摘要:7.1 KMeans Clustering iris = pd.read_csv('/Users/iris.csv')iris["Species"] = np.where(iris["Target"] == 0, "Setosa", np.where(iris["Target"] == 1, "Ve 阅读全文
SQL Sever check table size
2019-07-29 16:28 by nuswgg, 310 阅读, 0 推荐, 收藏, 编辑
摘要:SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 阅读全文
EXCEL OUTLOOK ACCESS 帮助
2018-12-26 15:45 by nuswgg, 253 阅读, 0 推荐, 收藏, 编辑
摘要:Excel Application Object (Excel) Workbooks Object (Excel) Workbook Object (Excel) Worksheet Object (Excel) Range Object (Excel) Workbook.SaveAs Method 阅读全文
Pandas Cheat Sheet
2017-12-17 22:09 by nuswgg, 296 阅读, 0 推荐, 收藏, 编辑
摘要:Pandas Doc: http://pandas.pydata.org/pandas-docs/stable/10min.html#min 阅读全文
Python Tutorial: Preparation & Basic Regression
2017-12-12 15:36 by nuswgg, 255 阅读, 0 推荐, 收藏, 编辑
摘要:5.1 Pre-process a data set using principal component analysis. # Notice we are using a new data set that needs to be read into the # environment iris 阅读全文
Python Tutorial: More Advanced Data Wrangling
2017-12-12 15:18 by nuswgg, 182 阅读, 0 推荐, 收藏, 编辑
摘要:Drop observations with missing information. pandas.DataFrame.dropna Merge two data sets together on a common variable. # Notice the use of the student 阅读全文