🔒 Compare data in two files that has no primary key but has duplicate values

[pseudo dove]

@pulsar sage

Python help channel opened

Remember to:

• Ask your Python question, not if you can ask or if there's an expert who can help.
• Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
• Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.

[brave tree]

U want to keep only 1 of those that have duplicate ids?
d={i["id"]:i for i in data}
data=list(d)

Dicts in python are ordered so the order wont even change to idk if the first or the last is kept

[pulsar sage]

I need all of the records, the duplicated ID doesn't mean the entire record is duplicated. The ID is just repeated for each record.

[brave tree]

Can u give a small example?

[pulsar sage]

Hold on

I put File1 and File2 as sheets here

[brave tree]

!paste

[pseudo dove]

Pasting large amounts of code

If your code is too long to fit in a codeblock in Discord, you can paste your code here:
https://paste.pythondiscord.com/

After pasting your code, save it by clicking the Paste! button in the bottom left, or by pressing CTRL + S. After doing that, you will be navigated to the new paste's page. Copy the URL and post it here so others can see it.

[pulsar sage]

Do you want the code?

[brave tree]

No i want example input and output

And i prefer json if u dont already have it in something else

[pseudo dove]

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

🔒 Compare data in two files that has no primary key but has duplicate values