My software version
Python version: 3.7.0
Pycharm version:pycharm-professional-2018.2.3
numply version:1.15.1
pandas version: 0.23.4
I worked with Json file by extract the specific data from it, and then store it in csv file.
My code can run for a while and then it stop with
Process finished with exit code -1073741819 (0xC0000005)
so i am run code continuously from last stop. It can work for a while and this exit code is happen agian. I do not why this exit code is happen while i am running code ().
Here is my code
import pandas as pd
import numpy
def test_write():
names = pd.read_csv('order_list.txt', names=["key"], encoding='utf-8')
list_csv = [["IssueKey", "Title", "Component", "Description"]]
df = pd.DataFrame(list_csv)
df.to_csv("testcsv.csv", index=False, header=None)
i=0
while i<10000:
file_name = str(names["key"][i]) + ".json"
data = pd.read_json("C:/Users/chthi/Desktop/dataset/" + str(file_name), encoding='utf-8')
id = data["key"].head(1)[0]
summary = data["fields"]["summary"]
description = data["fields"]["description"]
if description is None:
_description = "None"
else:
_description = description.replace("\n","")
_description = _description.replace("\r", "")
components = data["fields"]["components"]
str_compo = ""
for line in components:
str_compo += line["name"] + ","
list = []
list.append([id, summary, str_compo[:len(str_compo) - 1], _description])
df = pd.DataFrame(list)
df.to_csv("testcsv.csv", mode="a", index=False, header=None)
print(file_name)
i+=1
print("File is Created Successfully")
User contributions licensed under CC BY-SA 3.0