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
以上就是Microsoft Excel 新短代码的详细内容,更多请关注php中文网其它相关文章!
版权声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系 yyfuon@163.com