如何从文本文件中提取经度和纬度？

Question

我有一个称为iplocation.txt的文本文件，

   {"ip":"222.255.27.184","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0}
   {"ip":"222.255.27.187","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0}
   {"ip":"222.255.27.45","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0}

我只想要坐标。我需要一些帮助才能使数据看起来像这样：

latitude 21.0313 longitude 105.8516
latitude 21.0313 longitude 105.8516
latitude 21.0313 longitude 105.8516

我知道Grep和Awk。但是，我是初学者。到目前为止，我花了一些时间搜索和实验，没有运气。我还没有找到道路。帮助！

Answer 1

在Python中运行此。

如果您的文件是Excel文件

import pandas as pd

files = [
    {"ip":"222.255.27.184","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0},
    {"ip":"222.255.27.187","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0},
    {"ip":"222.255.27.45","country_code":"VN","country_name":"Vietnam","region_code":"HN","region_name":"Hanoi","city":"Hanoi","zip_code":"","time_zone":"Asia/Bangkok","latitude":21.0313,"longitude":105.8516,"metro_code":0}
]

object = {
    "latitude": 123, # Here I am creating an object, these are example values in the key,value pair
    "longitude": 123
}

final_output = []
for file in files:
    object["latitude"] = file['latitude']
    object["longitude"] = file['longitude']
    final_output.append(object)

df = pd.DataFrame(final_output)
df.to_csv(r"C:\Users\User\Downloads\saved.csv") # This will save it to your downloads folder, or just replace the path to anything else

print(final_output)

结果：在Excel中打开的文件。