<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://tech.uvoo.io/index.php?action=history&amp;feed=atom&amp;title=Pandas_dns_csv</id>
	<title>Pandas dns csv - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://tech.uvoo.io/index.php?action=history&amp;feed=atom&amp;title=Pandas_dns_csv"/>
	<link rel="alternate" type="text/html" href="https://tech.uvoo.io/index.php?title=Pandas_dns_csv&amp;action=history"/>
	<updated>2026-04-24T17:45:46Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.35.2</generator>
	<entry>
		<id>https://tech.uvoo.io/index.php?title=Pandas_dns_csv&amp;diff=5256&amp;oldid=prev</id>
		<title>Busk: Created page with &quot;``` #!/usr/bin/env python3  import csv import sys  import dns.resolver import numpy as np import time import pandas as pd  def query_dns_a_record(domain, resolver_ip):     # p...&quot;</title>
		<link rel="alternate" type="text/html" href="https://tech.uvoo.io/index.php?title=Pandas_dns_csv&amp;diff=5256&amp;oldid=prev"/>
		<updated>2024-05-07T18:48:25Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;``` #!/usr/bin/env python3  import csv import sys  import dns.resolver import numpy as np import time import pandas as pd  def query_dns_a_record(domain, resolver_ip):     # p...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;```&lt;br /&gt;
#!/usr/bin/env python3&lt;br /&gt;
&lt;br /&gt;
import csv&lt;br /&gt;
import sys&lt;br /&gt;
&lt;br /&gt;
import dns.resolver&lt;br /&gt;
import numpy as np&lt;br /&gt;
import time&lt;br /&gt;
import pandas as pd&lt;br /&gt;
&lt;br /&gt;
def query_dns_a_record(domain, resolver_ip):&lt;br /&gt;
    # print(domain)&lt;br /&gt;
    # print(resolver_ip)&lt;br /&gt;
    ext = dns.resolver.Resolver(configure=False)&lt;br /&gt;
    ext.nameservers = ['8.8.8.8']&lt;br /&gt;
    try:&lt;br /&gt;
        result = ext.resolve(domain, 'A')&lt;br /&gt;
        return [str(rdata) for rdata in result]&lt;br /&gt;
&lt;br /&gt;
    except (dns.resolver.NoAnswer, dns.resolver.NXDOMAIN):&lt;br /&gt;
        # print(f&amp;quot;Could not resolve {domain}&amp;quot;)&lt;br /&gt;
        return []&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
def strip_quotes(val):&lt;br /&gt;
    return val.replace('&amp;quot;', '')&lt;br /&gt;
&lt;br /&gt;
def get_cname():&lt;br /&gt;
    df = pd.read_csv('CNAME.csv', converters={i: strip_quotes for i in range(100)})&lt;br /&gt;
    for index, row in df.iterrows():&lt;br /&gt;
        # print(row['Name'], row['Data'])&lt;br /&gt;
        records = query_dns_a_record(row['Data'], &amp;quot;8.8.8.8&amp;quot;)&lt;br /&gt;
        print(f&amp;quot;{row['Data']} {records}&amp;quot;)&lt;br /&gt;
        # time.sleep(5)&lt;br /&gt;
&lt;br /&gt;
def get_a():&lt;br /&gt;
    df = pd.read_csv('A.csv', converters={i: strip_quotes for i in range(100)})&lt;br /&gt;
    for index, row in df.iterrows():&lt;br /&gt;
        if &amp;quot;66.133&amp;quot; in row['Data']:&lt;br /&gt;
            print(f&amp;quot;{row['Name']}.{row['Zone']} {row['Data']}&amp;quot;)&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
def xget_a(filename, mstring):&lt;br /&gt;
    with open(filename, 'r') as csvfile:&lt;br /&gt;
        csvreader = csv.reader(csvfile)&lt;br /&gt;
        for row in csvreader:&lt;br /&gt;
            if mstring in row[3]:&lt;br /&gt;
                print(row[1], row[3])&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
# get_a()&lt;br /&gt;
get_cname()&lt;br /&gt;
```&lt;/div&gt;</summary>
		<author><name>Busk</name></author>
	</entry>
</feed>