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