Open in app

Sign In

Write

Sign In

chuxin huo
chuxin huo

1 Follower

Home

About

Jul 21, 2021

deduplicating for row-style Excel

A file has multiple columns of data. The first row is the column name, and the second row is the data record. Compare the key columns in the file, delete the duplicate rows in the key column or keep only the duplicate rows. The current sales order table order_2018.xlsx for…

2 min read

deduplicating for row-style Excel
deduplicating for row-style Excel

2 min read


Jul 21, 2021

Simple data deduplication

Example1 There is a sequence of numbers, you need to select the number that is not repeated. Write SPL script:

2 min read

Simple data deduplication
Simple data deduplication

2 min read

Simple data deduplication

Example1

There is a sequence of numbers, you need to select the number that is not repeated.

Write SPL script:

--

--


Jul 21, 2021

Deduplicating without changing original orders

Example The Excel file book1.xlsx has two columns of Car and Color. Part of the data is shown in the figure below:

2 min read

Deduplicating without changing original orders
Deduplicating without changing original orders

2 min read

Deduplicating without changing original orders

Example

The Excel file book1.xlsx has two columns of Car and Color. Part of the data is shown in the figure below:

--

--


Jul 21, 2021

Filter by repetitions

Example There is an Excel file Book1.xlsx, and part of the data is as follows:

1 min read

Filter by repetitions
Filter by repetitions

1 min read

Filter by repetitions

Example

There is an Excel file Book1.xlsx, and part of the data is as follows:

--

--


Jul 21, 2021

deduplicating with related columns

Example Example1 There is an Excel file Book1.xlsx, and part of the data is as follows:

2 min read

deduplicating with related columns
deduplicating with related columns

2 min read


Jul 21, 2021

Removal with paired data

Example There is an Excel file Book1.xlsx, and part of the data is as follows:

2 min read

Removal with paired data
Removal with paired data

2 min read

Removal with paired data

Example

There is an Excel file Book1.xlsx, and part of the data is as follows:

--

--


Jul 21, 2021

Counting repetitions

Example There is an Excel file mat.xlsx, part of the data is as follows:

1 min read

Counting repetitions
Counting repetitions

1 min read

Counting repetitions

Example

There is an Excel file mat.xlsx, part of the data is as follows:

--

--


Jul 21, 2021

counting repetitions for uncertain columns

Example There is an Excel file mat.xlsx, part of the data is as follows:

2 min read

counting repetitions for uncertain columns
counting repetitions for uncertain columns

2 min read

counting repetitions for uncertain columns

Example

There is an Excel file mat.xlsx, part of the data is as follows:

--

--


Jul 21, 2021

Find duplicates and counting

Example There is an Excel file Book1.xlsx, part of the data is as follows:

1 min read

Find duplicates and counting
Find duplicates and counting

1 min read

Find duplicates and counting

Example

There is an Excel file Book1.xlsx, part of the data is as follows:

--

--


Jul 9, 2021

An uncertain number of sets to find intersection, union, and difference

Example There are multiple Excel files Book1.xlsx, Book2.xlsx, Book3.xlsx,…, the naming rule of these files is Book[N].xlsx, N is a number starting from 1, the data in the file is as follows: Book1.xlsx

2 min read

An uncertain number of sets to find intersection, union, and difference
An uncertain number of sets to find intersection, union, and difference

2 min read

An uncertain number of sets to find intersection, union, and difference

Example

There are multiple Excel files Book1.xlsx, Book2.xlsx, Book3.xlsx,…, the naming rule of these files is Book[N].xlsx, N is a number starting from 1, the data in the file is as follows:

Book1.xlsx

--

--

chuxin huo

chuxin huo

1 Follower

hello:)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech