Comparing 2 CSV files with Domain and IP. Rows are in different order. Reading Row 1 File X compare with all Rows in File Y
I ended up using cli53 and that provided me with a pretty clean list of all Records in our zone. I then used find and replace to add a comma to all the values and imported this into excel.
That was the best solution for my particular use case.
so i've looked online at a far exmaples but they all seem to assume the data is in order.
So Row 1 in Both files has the same information.
In my case Row 1 File X has an IP and DNS. The idea is to check if this IP address can be found in any of the rows in File Y.
Ideally I'd get a list of IP addresses not found in File Y.
I tried to import the files into Pandas but thats about where my knowledge ends.
Edit: Sample
File 1
dns,ip
what.dont.cz.,12.34.21.90
........
File 2
ip,dns
1.32.20.25, sea.ocean.cz
........
12.34.21.90 what.dont.cz
..........