How to generate JSON from the csv file in Python?












3















I am trying to construct a Json structure from the csv file. This below code gives me the error stating :- AttributeError: 'tuple' object has no attribute 'to_json' . I am new to python world and would like to ask for your help on this.



CSV Data Look like this:



enter image description here



I want output to be like below



[

    {"Variable": "Latitude",

    "Min": "78",

    "Q1": "89"} ,



    {"Variable": "Longitude",

    "Min": "78",

    "Q1": "89"},

    {"Variable": "Zip",

    "Min": "78",

    "Q1": "89"}

]



import pandas    

res_data = pd.read_csv("C\Documents\abc.csv", 'r')

abc=res_data.to_json(orient='records')

print(abc)





python json python-3.x python-2.7 pandas







share|improve this question




















  • 1





    What is res_df here?

    – Daniel Roseman
    Nov 16 '18 at 8:47
















3















I am trying to construct a Json structure from the csv file. This below code gives me the error stating :- AttributeError: 'tuple' object has no attribute 'to_json' . I am new to python world and would like to ask for your help on this.



CSV Data Look like this:



enter image description here



I want output to be like below



[

    {"Variable": "Latitude",

    "Min": "78",

    "Q1": "89"} ,



    {"Variable": "Longitude",

    "Min": "78",

    "Q1": "89"},

    {"Variable": "Zip",

    "Min": "78",

    "Q1": "89"}

]



import pandas    

res_data = pd.read_csv("C\Documents\abc.csv", 'r')

abc=res_data.to_json(orient='records')

print(abc)





python json python-3.x python-2.7 pandas







share|improve this question




















  • 1





    What is res_df here?

    – Daniel Roseman
    Nov 16 '18 at 8:47














3












3








3








I am trying to construct a Json structure from the csv file. This below code gives me the error stating :- AttributeError: 'tuple' object has no attribute 'to_json' . I am new to python world and would like to ask for your help on this.



CSV Data Look like this:



enter image description here



I want output to be like below



[

    {"Variable": "Latitude",

    "Min": "78",

    "Q1": "89"} ,



    {"Variable": "Longitude",

    "Min": "78",

    "Q1": "89"},

    {"Variable": "Zip",

    "Min": "78",

    "Q1": "89"}

]



import pandas    

res_data = pd.read_csv("C\Documents\abc.csv", 'r')

abc=res_data.to_json(orient='records')

print(abc)





python json python-3.x python-2.7 pandas







share|improve this question
















I am trying to construct a Json structure from the csv file. This below code gives me the error stating :- AttributeError: 'tuple' object has no attribute 'to_json' . I am new to python world and would like to ask for your help on this.



CSV Data Look like this:



enter image description here



I want output to be like below



[

    {"Variable": "Latitude",

    "Min": "78",

    "Q1": "89"} ,



    {"Variable": "Longitude",

    "Min": "78",

    "Q1": "89"},

    {"Variable": "Zip",

    "Min": "78",

    "Q1": "89"}

]



import pandas    

res_data = pd.read_csv("C\Documents\abc.csv", 'r')

abc=res_data.to_json(orient='records')

print(abc)





python json python-3.x python-2.7 pandas




python json python-3.x python-2.7 pandas






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 16 '18 at 8:59







Shankar Panda

















asked Nov 16 '18 at 8:43









Shankar PandaShankar Panda

1691215




1691215








  • 1





    What is res_df here?

    – Daniel Roseman
    Nov 16 '18 at 8:47














  • 1





    What is res_df here?

    – Daniel Roseman
    Nov 16 '18 at 8:47








1




1





What is res_df here?

– Daniel Roseman
Nov 16 '18 at 8:47





What is res_df here?

– Daniel Roseman
Nov 16 '18 at 8:47












3 Answers
3






active

oldest

votes


















2














import json

import pandas as pd    

df = pd.read_csv("path_of_csv")

js = df.to_json(orient="records")

json.loads(js)


Output:



[{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},

 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},

 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]





share|improve this answer
























  • Perfect. Simple and best

    – Shankar Panda
    Nov 16 '18 at 9:01



















0














Something like



import csv

import json



csvfile = open('file.csv', 'r')

jsonfile = open('file.json', 'w')



fieldnames = ("variable", "min", "Q1")

reader = csv.DictReader( csvfile, fieldnames)

for row in reader:

    json.dump(row, jsonfile)

    jsonfile.write('n')





share|improve this answer
























  • It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

    – Shankar Panda
    Nov 16 '18 at 9:02



















0














You can try simply using csv module.



import csv

import json



output_dict = 

with open('abc.csv') as csvfile:

    reader = csv.DictReader(csvfile)

    for row in reader:

        output_dict.append(row)



print json.dumps(output_dict)


output_dict will contain list of dict of include all rows. json.dumps will convert python dict to json.



and output will be:



[{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},

 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},

 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]


More details abou csv.DictReader : enter link description here






share|improve this answer
























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53334238%2fhow-to-generate-json-from-the-csv-file-in-python%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    3 Answers
    3






    active

    oldest

    votes








    3 Answers
    3






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    import json
    
import pandas as pd    
    
df = pd.read_csv("path_of_csv")
    
js = df.to_json(orient="records")
    
json.loads(js)


    Output:



    [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
    
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
    
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]





    share|improve this answer
























    • Perfect. Simple and best

      – Shankar Panda
      Nov 16 '18 at 9:01
















    2














    import json
    
import pandas as pd    
    
df = pd.read_csv("path_of_csv")
    
js = df.to_json(orient="records")
    
json.loads(js)


    Output:



    [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
    
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
    
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]





    share|improve this answer
























    • Perfect. Simple and best

      – Shankar Panda
      Nov 16 '18 at 9:01














    2












    2








    2







    import json
    
import pandas as pd    
    
df = pd.read_csv("path_of_csv")
    
js = df.to_json(orient="records")
    
json.loads(js)


    Output:



    [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
    
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
    
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]





    share|improve this answer













    import json
    
import pandas as pd    
    
df = pd.read_csv("path_of_csv")
    
js = df.to_json(orient="records")
    
json.loads(js)


    Output:



    [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
    
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
    
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]






    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Nov 16 '18 at 8:56









    Srce CdeSrce Cde

    1,184612




    1,184612













    • Perfect. Simple and best

      – Shankar Panda
      Nov 16 '18 at 9:01



















    • Perfect. Simple and best

      – Shankar Panda
      Nov 16 '18 at 9:01

















    Perfect. Simple and best

    – Shankar Panda
    Nov 16 '18 at 9:01





    Perfect. Simple and best

    – Shankar Panda
    Nov 16 '18 at 9:01













    0














    Something like



    import csv
    
import json
    

    
csvfile = open('file.csv', 'r')
    
jsonfile = open('file.json', 'w')
    

    
fieldnames = ("variable", "min", "Q1")
    
reader = csv.DictReader( csvfile, fieldnames)
    
for row in reader:
    
    json.dump(row, jsonfile)
    
    jsonfile.write('n')





    share|improve this answer
























    • It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

      – Shankar Panda
      Nov 16 '18 at 9:02
















    0














    Something like



    import csv
    
import json
    

    
csvfile = open('file.csv', 'r')
    
jsonfile = open('file.json', 'w')
    

    
fieldnames = ("variable", "min", "Q1")
    
reader = csv.DictReader( csvfile, fieldnames)
    
for row in reader:
    
    json.dump(row, jsonfile)
    
    jsonfile.write('n')





    share|improve this answer
























    • It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

      – Shankar Panda
      Nov 16 '18 at 9:02














    0












    0








    0







    Something like



    import csv
    
import json
    

    
csvfile = open('file.csv', 'r')
    
jsonfile = open('file.json', 'w')
    

    
fieldnames = ("variable", "min", "Q1")
    
reader = csv.DictReader( csvfile, fieldnames)
    
for row in reader:
    
    json.dump(row, jsonfile)
    
    jsonfile.write('n')





    share|improve this answer













    Something like



    import csv
    
import json
    

    
csvfile = open('file.csv', 'r')
    
jsonfile = open('file.json', 'w')
    

    
fieldnames = ("variable", "min", "Q1")
    
reader = csv.DictReader( csvfile, fieldnames)
    
for row in reader:
    
    json.dump(row, jsonfile)
    
    jsonfile.write('n')






    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Nov 16 '18 at 8:46









    elkenelken

    138110




    138110













    • It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

      – Shankar Panda
      Nov 16 '18 at 9:02



















    • It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

      – Shankar Panda
      Nov 16 '18 at 9:02

















    It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

    – Shankar Panda
    Nov 16 '18 at 9:02





    It works but not generating the proper json structure. There should be comma separated for each row and the whole json should be enclosed in

    – Shankar Panda
    Nov 16 '18 at 9:02











    0














    You can try simply using csv module.



    import csv
    
import json
    

    
output_dict = 
    
with open('abc.csv') as csvfile:
    
    reader = csv.DictReader(csvfile)
    
    for row in reader:
    
        output_dict.append(row)
    

    
print json.dumps(output_dict)


    output_dict will contain list of dict of include all rows. json.dumps will convert python dict to json.



    and output will be:



    [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
    
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
    
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]


    More details abou csv.DictReader : enter link description here






    share|improve this answer




























      0














      You can try simply using csv module.



      import csv
      
import json
      

      
output_dict = 
      
with open('abc.csv') as csvfile:
      
    reader = csv.DictReader(csvfile)
      
    for row in reader:
      
        output_dict.append(row)
      

      
print json.dumps(output_dict)


      output_dict will contain list of dict of include all rows. json.dumps will convert python dict to json.



      and output will be:



      [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
      
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
      
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]


      More details abou csv.DictReader : enter link description here






      share|improve this answer


























        0












        0








        0







        You can try simply using csv module.



        import csv
        
import json
        

        
output_dict = 
        
with open('abc.csv') as csvfile:
        
    reader = csv.DictReader(csvfile)
        
    for row in reader:
        
        output_dict.append(row)
        

        
print json.dumps(output_dict)


        output_dict will contain list of dict of include all rows. json.dumps will convert python dict to json.



        and output will be:



        [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
        
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
        
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]


        More details abou csv.DictReader : enter link description here






        share|improve this answer













        You can try simply using csv module.



        import csv
        
import json
        

        
output_dict = 
        
with open('abc.csv') as csvfile:
        
    reader = csv.DictReader(csvfile)
        
    for row in reader:
        
        output_dict.append(row)
        

        
print json.dumps(output_dict)


        output_dict will contain list of dict of include all rows. json.dumps will convert python dict to json.



        and output will be:



        [{'variable': 'Latitude', 'min': 26.84505, 'Q1': 31.19725},
        
 {'variable': 'Longtitude', 'min': -122.315, 'Q1': -116.558},
        
 {'variable': 'Zip', 'min': 20910.0, 'Q1': 32788.5}]


        More details abou csv.DictReader : enter link description here







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 16 '18 at 9:04









        Harsha BiyaniHarsha Biyani

        2,72321834




        2,72321834






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53334238%2fhow-to-generate-json-from-the-csv-file-in-python%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            List item for chat from Array inside array React Native

            Image
            0 This is my code for Chat Box, the window where I have "In" and "Out" messages are appearing. import React, { Component } from "react"; import { StyleSheet, Text, View, TouchableOpacity, TextInput, FlatList, Platform, AsyncStorage } from "react-native"; import Tutor from "../image/krutika.jpg"; import { Container, Header, Left, Input, Body, Right, Thumbnail, Button } from "native-base"; import FontAwesome from "react-native-vector-icons/FontAwesome"; import Ionicons from "react-native-vector-icons/Ionicons"; import Icon1 from "react-native-vector-icons/FontAwesome"; import axios from "axios"; export default class ChatBox extends Component { st...
            Read more

            Thiostrepton

            Image
            Thiostrepton [1] Names Other names Alaninamide, Bryamycin, Thiactin Identifiers CAS Number 1393-48-2   Y 3D model (JSmol) Interactive image ChEMBL ChEMBL468719   N ECHA InfoCard 100.014.304 PubChem CID 16130278 InChI InChI=1S/C72H85N19O18S5/c1-14-26(3)47-63(105)78-30(7)57(99)75-28(5)56(98)76-31(8)58(100)91-72-19-18-40(66-85-43(22-111-66)59(101)77-29(6)55(97)74-27(4)54(73)96)81-52(72)42-21-112-67(83-42)49(34(11)109-69(107)41-20-37(32(9)92)36-16-17-39(79-47)51(95)50(36)80-41)89-60(102)44-24-113-68(86-44)53(71(13,108)35(12)94)90-62(104)45-23-110-65(84-45)38(15-2)82-64(106)48(33(10)93)88-61(103)46-25-114-70(72)87-46/h15-17,20-22,24-26,30-35,39,45,47-49,51-53,79,92-95,108H,4-6,14,18-19,23H2,1-3,7-13H3,(H2,73,96)(H,74,97)(H,75,99)(H,76,98)(H,77,101)(H,78,105)(H,82,106)(H,88,103)(H,89,102)(H,90,104)(H,91,100)/b38-15-/t26-,30-,31-,32-,33+,34+,35+,39+,45+,47-,48-,49-,51-,52+,53+,71+,72+/m0/s1 Key: NSFFHOGKXHRQEW-AIHSUZKVSA-N ...
            Read more

            Caerphilly

            Image
            This article is about the town of Caerphilly. For the cheese of the same name, see Caerphilly cheese. For other uses, see Caerphilly (disambiguation). Caerphilly Welsh: Caerffili Caerphilly Castle Caerphilly Location within Caerphilly Population 30,388  OS grid reference ST1586 Principal area Caerphilly Ceremonial county Gwent Country Wales Sovereign state United Kingdom Post town CAERPHILLY Postcode district CF83 Dialling code 029 Police Gwent Fire South Wales Ambulance Welsh EU Parliament Wales UK Parliament Caerphilly Welsh Assembly Caerphilly List of places UK Wales Caerphilly 51°34′41″N 3°13′05″W  /  51.578°N 3.218°W  / 51.578; -3.218 Coordinates: 51°34′41″N 3°13′05″W  /  51.578°N 3.218°W  / 51.578; -3.218 Caerphilly ( / k aɪər ˈ f ɪ l i / ; Welsh: Caerffili , Welsh pronunciation:  [ˌkɑːɨrˈfɪlɪ] ) is a town and community in South Wales, at the southern end of the Rhymney Valley....
            Read more