Create example data | Basic operations | Filter rows | Sort rows | Select columns | Summarise data | group computation (by) | Going further | Advanced columns manipulation | Advanced use of by | Miscellaneous | Read / Write data | Reshape data | Other | Join/Bind data sets | Join | Bind | Set operations | Summary

Why tidyft? | The philosophy of tidyft | Working with fst | Performance | Session Information

Q1 | Q2 | Q3 | Q4 | Q5 | Last words | Session information

Use tidyfst just like dplyr | Filter rows with filter_dt() | Arrange rows with arrange_dt() | Select columns with select_dt() | Add new columns with mutate_dt() | Summarise values with summarise_dt() | Randomly sample rows with sample_n_dt() and sample_frac_dt() | Grouped operations | Comparison with data.table syntax | Data | Subset rows | Select column(s) | Mixed computation | Refer to columns by names | Aggregations

Controlling how the tables are matched | Types of join | Filtering joins | Set operations

Longer | Wider | More complicated example

Inspect the data | Get the dictionary from keyword field | Extract keywords from abstract | Merge keywords with same meanings | Divide keywords into groups (automatic classification) | Get the grouped table | Visualization of the network

测试数据构造 | 基础 | 小技巧 | 聚合 | 1.求每种切割类型、每种颜色钻石的平均价格、中位数价格与最高价格 | 2.求每天最高出售价格对应的那笔订单 | join | 1.dat1与dat2以dt列左连接 | 2.多重join | 长宽表转换 | 1.长表转宽表 | 2.宽表转长表 | 高阶 | 向上/下填充空值 | 添加子维度聚合结果为新列 | 1.以dat1为例，添加两列，一列为以cut、color聚合求price的均值，另一列是求标准差 | 2.以dat1为例，以dt分组添加一列序号id | 移动函数 | 系统参数

Introduction | Features | Example | Load package and inspect data | Keyword cleaning | Keyword merging | Keyword grouping | Output the table of results | Visualize the results | Keyword extraction from abstract | END