In [1]:
# Standard Imports.
import numpy as np
import pandas as pd
import csv
import json
In [2]:
src_df = []
# Reading input file.
with open('C:\\Users\\sh242807\\workarea\\appconfig-data-migration\\round2\\app-migration_2018-09-27 09_43_01.782.csv') as f:
lines = csv.reader(f, delimiter=",", quotechar='"')
for line in lines:
src_df.append(line)
In [9]:
key_list = set()
for i in range(1, 1675):
urls = json.loads(src_df[i][8])
for j in urls:
key_list.add(j["key"])
In [11]:
df = pd.read_csv('C:\\Users\\sh242807\\workarea\\appconfig-data-migration\\round2\\app-migration_2018-09-27 09_43_01.782.csv')
In [13]:
wrk = df.iloc[:, [0,5,6,7]].copy()
In [ ]:
for i in list(key_list):
wrk.
In [14]:
wrk.head()
Out[14]: