Microsoft Excel 新短代码

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