多多校园网络店铺
v3.3增加是否允许用户注册选项，重些登陆验证代码，取消SessionTimeout设置，改成前后台登陆验证设置，重写短消息单元，所有短信功能在个页面完成，更改相关短信连接和图片设置，美化相关小图片，修正若干个小问题，全新界面正装上市丰富用户字段，重命名相关文件，以方便使用管理，适合开发规范，重写修改密码，修改资料，店铺标志上传，店铺公告，店铺连接代码，店铺资料修改，商品发布、修改、删除功能，二手
下载
VLOOKUP: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
INDEX/MATCH: =INDEX(range, MATCH(lookup_value, lookup_array, [match_type])
PivotTable: =SUMIFS(sum_range, criteria_range, criteria)
Conditional Formatting: =A1>average(A:A)
Chart creation: =SERIES(name, categories, values)
Data Analytics/Science (Python):
Dataframe creation: df = pd.DataFrame({'column1': [1, 2, 3], 'column2': [4, 5, 6]})
Data merging: pd.merge(df1, df2, on='common_column')
GroupBy: df.groupby('column').sum()
Data visualization: plt.plot(df['column'])
Machine Learning: from sklearn.linear_model import LinearRegression; model = LinearRegression()
SQL:
Data insertion: INSERT INTO table (column1, column2) VALUES ('value1', 'value2');
Data update: UPDATE table SET column = 'new_value' WHERE condition;
Data deletion: DELETE FROM table WHERE condition;
Table creation: CREATE TABLE table (column1 data_type, column2 data_type);
Index creation: CREATE INDEX index_name ON table (column);
R:
Dataframe creation: df <- data.frame(column1 = c(1, 2, 3), column2 = c(4, 5, 6))
Data merging: merge(df1, df2, by = 'common_column')
GroupBy: aggregate(df$column, by = list(df$group), FUN = sum)
Data visualization: ggplot(df, aes(x = column)) + geom_bar()
Machine Learning: library(caret); model <- train(column ~ ., data = df)
Regular Expressions (regex):
Match email: \b[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,}\b
Match phone number: \d{3}[-.]?\d{3}[-.]?\d{4}
Match date (YYYY-MM-DD): \d{4}[-.]\d{2}[-.]\d{2}
