Styjun

Large-n limit of the distribution of the normalized sum of Cauchy random variables

I calculated that we should be able to see the sun well beyond the observable universe. Where did I go wrong?

What is that ceiling compartment of a Boeing 737?

Densest sphere packing

Why is it 出差去 and not 去出差?

「捨ててしまう」why is there two て’s used here?

Print the new site header

What is the maximum that Player 1 can win?

First occurrence in the Sixers sequence

Setting up the trap

How can a warlock learn from a spellbook?

King or Queen-Which piece is which?

Do details of my undergraduate title matter?

What does this Swiss black on yellow rectangular traffic sign with a symbol looking like a dart mean?

Why does a Force divides equally on a Multiple Support/Legs?

How to make all magic-casting innate, but still rare?

The Amazing Sliding Crossword

How Hebrew Vowels Work

Umlaut character order when sorting

Is there any possible way to get these hearts as Adult Link?

Counterfeit checks were created for my account. How does this type of fraud work?

How to take photos with a yellowish tone and point-and-shoot film camera look?

What mathematical theory is required for high frequency trading?

I found a password with hashcat but it doesn't work

converting csv file into json format in python

How to check for specific field values based on some condition while converting csv file to json formatHow do I check whether a file exists without exceptions?Calling an external command in PythonWhat are metaclasses in Python?How do I format a Microsoft JSON date?Can comments be used in JSON?Does Python have a ternary conditional operator?What is the correct JSON content type?Why does Google prepend while(1); to their JSON responses?How do I list all files of a directory?Does Python have a string 'contains' substring method?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have written a code to convert my csvfile which is '|' delimited file to get specific json format.

Csv file format:

comment|address|city|country
crowded|others|others|US
pretty good|others|others|US .... 

I have tried with other codes as well since I'm new to python I'm stuck in between. If somebody helps me to correct the mistake I'm doing it would be helpful.

import csv
import json
from collections import OrderedDict

csv_file = 'test.csv'
json_file = csv_file + '.json'


def main(input_file):
 csv_rows = []
 with open(input_file, 'r') as csvfile:
 reader = csv.DictReader(csvfile)
 title = reader.fieldnames
 for row in reader:
 entry = OrderedDict()
 for field in title:
 entry[field] = row[field]
 csv_rows.append(entry)

 with open(json_file, 'w') as f:
 json.dump(csv_rows, f, sort_keys=True, indent=4, ensure_ascii=False)
 f.write('n')


if __name__ == "__main__":
 main(csv_file)

I want in json format as below

{ 
 "reviewer": 
 "city": "",
 "country": "" 
 "address": "Orlando, Florida"
 ,

But I'm getting output like this:

[
 "COUNTRY":"Crowded",
 "Others",

python json python-2.7 csv

share|improve this question

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how to get the same output in nested json format? I'm getting in this format.[ "ADDRESS": "Others", "CITY": "Others", "COUNTRY": "Others" ] But I want the output in nested json format like "reviewer": "city": "", "country": "" "address": "Orlando, Florida"
  
  – megsh
  Mar 25 at 11:17
  
  

  
  
  
  

add a comment | 

0

I have written a code to convert my csvfile which is '|' delimited file to get specific json format.

Csv file format:

comment|address|city|country
crowded|others|others|US
pretty good|others|others|US .... 

I have tried with other codes as well since I'm new to python I'm stuck in between. If somebody helps me to correct the mistake I'm doing it would be helpful.

import csv
import json
from collections import OrderedDict

csv_file = 'test.csv'
json_file = csv_file + '.json'


def main(input_file):
 csv_rows = []
 with open(input_file, 'r') as csvfile:
 reader = csv.DictReader(csvfile)
 title = reader.fieldnames
 for row in reader:
 entry = OrderedDict()
 for field in title:
 entry[field] = row[field]
 csv_rows.append(entry)

 with open(json_file, 'w') as f:
 json.dump(csv_rows, f, sort_keys=True, indent=4, ensure_ascii=False)
 f.write('n')


if __name__ == "__main__":
 main(csv_file)

I want in json format as below

{ 
 "reviewer": 
 "city": "",
 "country": "" 
 "address": "Orlando, Florida"
 ,

But I'm getting output like this:

[
 "COUNTRY":"Crowded",
 "Others",

python json python-2.7 csv

share|improve this question

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  how to get the same output in nested json format? I'm getting in this format.[ "ADDRESS": "Others", "CITY": "Others", "COUNTRY": "Others" ] But I want the output in nested json format like "reviewer": "city": "", "country": "" "address": "Orlando, Florida"
  
  – megsh
  Mar 25 at 11:17
  
  

  
  
  
  

add a comment | 

I have written a code to convert my csvfile which is '|' delimited file to get specific json format.

Csv file format:

comment|address|city|country
crowded|others|others|US
pretty good|others|others|US .... 

I have tried with other codes as well since I'm new to python I'm stuck in between. If somebody helps me to correct the mistake I'm doing it would be helpful.

import csv
import json
from collections import OrderedDict

csv_file = 'test.csv'
json_file = csv_file + '.json'


def main(input_file):
 csv_rows = []
 with open(input_file, 'r') as csvfile:
 reader = csv.DictReader(csvfile)
 title = reader.fieldnames
 for row in reader:
 entry = OrderedDict()
 for field in title:
 entry[field] = row[field]
 csv_rows.append(entry)

 with open(json_file, 'w') as f:
 json.dump(csv_rows, f, sort_keys=True, indent=4, ensure_ascii=False)
 f.write('n')


if __name__ == "__main__":
 main(csv_file)

I want in json format as below

{ 
 "reviewer": 
 "city": "",
 "country": "" 
 "address": "Orlando, Florida"
 ,

But I'm getting output like this:

[
 "COUNTRY":"Crowded",
 "Others",

python json python-2.7 csv

share|improve this question

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

comment|address|city|country
crowded|others|others|US
pretty good|others|others|US .... 

import csv
import json
from collections import OrderedDict

csv_file = 'test.csv'
json_file = csv_file + '.json'


def main(input_file):
 csv_rows = []
 with open(input_file, 'r') as csvfile:
 reader = csv.DictReader(csvfile)
 title = reader.fieldnames
 for row in reader:
 entry = OrderedDict()
 for field in title:
 entry[field] = row[field]
 csv_rows.append(entry)

 with open(json_file, 'w') as f:
 json.dump(csv_rows, f, sort_keys=True, indent=4, ensure_ascii=False)
 f.write('n')


if __name__ == "__main__":
 main(csv_file)

{ 
 "reviewer": 
 "city": "",
 "country": "" 
 "address": "Orlando, Florida"
 ,

[
 "COUNTRY":"Crowded",
 "Others",

share|improve this question

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

share|improve this question

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

edited Mar 25 at 6:13

blhsing

47.2k51747

edited Mar 25 at 6:13

blhsing

47.2k51747

asked Mar 25 at 6:11

megshmegsh

63

asked Mar 25 at 6:11

megshmegsh

63

1 Answer
1

active

oldest

votes

1

You're missing the separator parameter. Instead of:

reader = csv.DictReader(csvfile)

Use:

reader = csv.DictReader(csvfile, delimiter='|')

share|improve this answer

answered Mar 25 at 6:16

hd1hd1

25.6k35869

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks. I got the json structure now.
  
  – megsh
  Mar 25 at 6:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How can I check for particular field value in the above program I have written. I have 2 fields 'recommendation' and 'rating'. Based on recommendation I need to set value for rating, like if recommendation is 1 then rating is 1 and vice versa
  
  – megsh
  Mar 25 at 6:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the link for other question. stackoverflow.com/questions/55333086/…
  
  – megsh
  Mar 25 at 7:36
  
  

  
  
  
  

add a comment | 

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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55332115%2fconverting-csv-file-into-json-format-in-python%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

You're missing the separator parameter. Instead of:

reader = csv.DictReader(csvfile)

Use:

reader = csv.DictReader(csvfile, delimiter='|')

share|improve this answer

answered Mar 25 at 6:16

hd1hd1

25.6k35869

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks. I got the json structure now.
  
  – megsh
  Mar 25 at 6:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How can I check for particular field value in the above program I have written. I have 2 fields 'recommendation' and 'rating'. Based on recommendation I need to set value for rating, like if recommendation is 1 then rating is 1 and vice versa
  
  – megsh
  Mar 25 at 6:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the link for other question. stackoverflow.com/questions/55333086/…
  
  – megsh
  Mar 25 at 7:36
  
  

  
  
  
  

add a comment | 

1

You're missing the separator parameter. Instead of:

reader = csv.DictReader(csvfile)

Use:

reader = csv.DictReader(csvfile, delimiter='|')

share|improve this answer

answered Mar 25 at 6:16

hd1hd1

25.6k35869

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks. I got the json structure now.
  
  – megsh
  Mar 25 at 6:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How can I check for particular field value in the above program I have written. I have 2 fields 'recommendation' and 'rating'. Based on recommendation I need to set value for rating, like if recommendation is 1 then rating is 1 and vice versa
  
  – megsh
  Mar 25 at 6:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This is the link for other question. stackoverflow.com/questions/55333086/…
  
  – megsh
  Mar 25 at 7:36
  
  

  
  
  
  

add a comment | 

You're missing the separator parameter. Instead of:

reader = csv.DictReader(csvfile)

Use:

reader = csv.DictReader(csvfile, delimiter='|')

share|improve this answer

answered Mar 25 at 6:16

hd1hd1

25.6k35869

reader = csv.DictReader(csvfile)

reader = csv.DictReader(csvfile, delimiter='|')

share|improve this answer

answered Mar 25 at 6:16

hd1hd1

25.6k35869

answered Mar 25 at 6:16

hd1hd1

25.6k35869

answered Mar 25 at 6:16

hd1hd1

25.6k35869