[Learning Path of Data Editing]

Chapter One Data Adding

1.1

Adding Data to a Subject

You can add data to a subject and edit the added data.

Overview of Adding Data

1.2

Data Editing Overview

You can learn about the data editing page and general function entries.

Data Editing Overview

1.3

Quick Start

You can learn about the data editing process.

Data Editing Use Guide

Chapter Two Basic Data Cleaning

2.1

Filter

You can filter data.

Filter

2.2

Sorting

You can sort data.

Sorting

2.3

Deleting Duplicate Rows

You can identify and remove duplicate rows from the data table.

Deleting Duplicate Rows

Chapter Three Data Structure Adjustment

3.1

Column Splitting

You can split a field into multiple fields.

Splitting Rows and Columns

3.2

Row Splitting

You can split a field into multiple rows.

Splitting Rows and Columns

3.3

Row to Column

You can transform the field values of a column into new field headers, typically used to convert a one-dimensional table into a two-dimensional table.

Changing Rows to Columns

3.4

Column to Row

You can convert a two-dimensional table into a one-dimensional table.

Changing Columns to Rows (Reverse Data Pivot)

3.5

Group Summary

Similar to PivotTable in Excel, the Group Summary function allows you to group data and perform summary calculations on the grouped data. The grouped and summarized data can change data granularity and structure.

Group Summary

3.6

Field Settings

1. You can change the field type.

2. You can modify the field name.

3. You can adjust the field order.

4. You can hide the field that is not required.

Field Settings

Chapter Four Multiple Table Analysis

4.1

Union All

You can merge multiple tables vertically into one table.

Union All

4.2

Join

You can merge the fields of multiple tables horizontally into one wide table.

Join

4.3

Adding a Column from Other Tables

You can add a column from other tables to the current table, enabling an effect similar to that of the LOOKUP or SUMIF function in Excel.

Column from Other Tables

Chapter Five Analysis Field Adding

5.1

Formula Column Adding

You can obtain new fields by calculating the original fields with formula functions.

Adding a Formula Column

5.2

Condition Label Column Adding

You can add conditions for the existing columns and set varied labels for rows with different conditions.

Adding a Condition Label Column

5.3

Summary Column Adding

You can perform summary calculations without affecting the existing fields and obtain the summary fields.

Adding a Summary Column

5.4

Assignment Column Adding

You can group data and add a group field.

Adding an Assignment Column

5.5

Time Interval

You can subtract two time fields and obtain the time interval.

Time Interval

5.6

Getting Time

You can obtain different time granularity values of an original data field.

Getting Time

Chapter Six Publication and Management

6.1

Data Management

You can edit, save, rename, move, delete, and update data, and save data as an analysis subject.

Data Management

6.2

Data Publishing

You can publish the processed data through Apply for Publication to Public Data for others to use.

Data Publishing

Chapter Seven Advanced Analysis of Multiple Tables: Subject Model

7.1

Getting Started with the Subject Model

The methods to perform the operations on the subject model are introduced.

Model View Overview and Construction Method

7.2

Understanding Model Usage Principle

The problems that can be solved by the model and the advantages of the model are introduced.

Getting Started with a Simple Example