Merge Hacker News runs into one list of unique stories

Created by

Rowcraft

Actor

Dataset Dedup and Merge API: Remove Duplicate Rows

Two runs of the Hacker News Scraper, for example the Top and the New list, merged into one dataset with every story once, keeping the copy from the later run (the fresher score and comment count). Replace the two dataset IDs with those of your own runs; the same works for any scraper that gives each row a stable ID.

Try for free

Dataset Dedup and Merge API: Remove Duplicate Rowsrowcraft/dataset-dedup-merge

ID of the dataset the kept row comes from

Position of the row in its source dataset, counting from 0

Number of copies of this row that were removed

Input

Datasets to merge(required):gEKpNK3WDGSntjXfB+1

Key fields (what makes a row a duplicate):id

Which copy to keep:last

Add source columns:true

Output fields

ID of the dataset the kept row comes from

Position of the row in its source dataset, counting from 0

Number of copies of this row that were removed

How it works

Sign up on Apify or log in

The Dataset Dedup and Merge API: Remove Duplicate Rows Actor is ready to run with the inputs already set for "Merge Hacker News runs into one list of unique stories". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Merge Hacker News runs into one list of unique stories" task

The Dataset Dedup and Merge API: Remove Duplicate Rows Actor will start running based on the input automatically. You can also change all the input fields, like datasets to merge, key fields (what makes a row a duplicate), and more, to match your specific use case.

Receive the "Merge Hacker News runs into one list of unique stories" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as ID of the dataset the kept row comes from, position of the row in its source dataset, counting from 0, and number of copies of this row that were removed.