esProc Desktop's Blog
Tag

Dataanalysis

#dataanalysis

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

#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

#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

#75 - Find out The Intervals in Which A Certain Condition Occurs Continuously

Oct 16, 20241 min read

Problem description & analysis: We have a statistical table for daily sales: Task: Find out the date when the sales rises for three consecutive days...

#75 - Find out The Intervals in Which A Certain Condition Occurs Continuously

#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)

Oct 15, 20241 min read

Problem description & analysis: We have an Excel table for the daily sales of products: Task: Find out products with the largest daily sales and...

#74 - Filter by Maximum Or Minimum Value within A Group (Find out One for Each Group)