esProc Desktop's Blog
Tag

dataanalytics

#dataanalytics

More content

Read more stories on Hashnode

Articles with this tag

#99 — Deduplication of Simple Data

Nov 19, 20241 min read

Problem description & analysis: There is a data table: Task: We want to duplicate the data. Solution: Use SPL XLL and enter the following...

#99 — Deduplication of Simple Data

#98 — Count Duplicates of Row-Based Data — by Key Column

Nov 18, 20241 min read

Problem description & analysis: Here below is a personnel data table: Task: Count the number of duplicate data (the judging basis is that the data in...

#98 — Count Duplicates of Row-Based Data — by Key Column

#96 — Identify Duplications of Row-Based Data — by Key Column

Nov 14, 20241 min read

Problem description & analysis: Here below is a personnel data table: Task: Identify whether there are duplicate data, if so, fill in 1 in the...

#96 — Identify Duplications of Row-Based Data — by Key Column

#95 — Identify Duplications of Simple Members

Nov 13, 20241 min read

Problem description and analysis: Here below is a data table of names: Task: Identify whether there are duplicate names, if so, fill in 1 in the...

#95 — Identify Duplications of Simple Members

#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole Row

Nov 12, 20241 min read

Problem description: The following tables list the data of the products and salespersons that make the top 10 by sales in January and...

#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole Row

#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key Column

Nov 11, 20241 min read

Problem description: The following tables list the sales data of the top 10 products by sales in January and February: Solutions: Use SPL XLL to...

#93 — Intersection, Union and Difference in the Case of Row-Based Data — Two Sets — by Key Column