Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Load and format a CSV file
#12
I don't fully understand objective but assuming that you have csv file named 'source-json.csv' with data on rows and want to have json one can simply do something along those lines:


import json
with open('source-json.csv', 'r') as f:
    d = {k: v.strip() for (k, v) in enumerate(f, start=1)}
    j = json.dumps(d)
One can write j to file or whatever:

Output:
{"1": "1231241231", "2": "1235135135", "3": "5457345345", "4": "4577865568", "5": "8654563848"}
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Da Bishop: There's a dead bishop on the landing. I don't know who keeps bringing them in here. ....but society is to blame.
Reply


Messages In This Thread
Load and format a CSV file - by fioranosnake - Oct-28-2019, 05:35 PM
RE: Load and format a CSV file - by perfringo - Oct-28-2019, 06:57 PM
RE: Load and format a CSV file - by snippsat - Oct-28-2019, 07:02 PM
RE: Load and format a CSV file - by Gribouillis - Oct-28-2019, 07:23 PM
RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 09:53 AM
RE: Load and format a CSV file - by snippsat - Oct-29-2019, 10:01 AM
RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 03:48 PM
RE: Load and format a CSV file - by snippsat - Oct-29-2019, 06:33 PM
RE: Load and format a CSV file - by fioranosnake - Oct-29-2019, 09:29 PM
RE: Load and format a CSV file - by snippsat - Oct-29-2019, 10:09 PM
RE: Load and format a CSV file - by fioranosnake - Oct-30-2019, 10:45 AM
RE: Load and format a CSV file - by perfringo - Oct-30-2019, 12:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to load all pages of the pdf file to the program alicenguyen 9 2,315 Jul-04-2022, 03:14 AM
Last Post: alicenguyen
  Reshape txt file into particular format using python shantanu97 0 1,438 Dec-10-2021, 11:44 AM
Last Post: shantanu97
  How can we transcode encoding file uml url format Anldra12 9 3,419 Jul-25-2021, 09:30 AM
Last Post: Anldra12
  How to design a save file format? philipbergwerf 5 4,167 Apr-26-2021, 07:39 PM
Last Post: Gribouillis
  CPC File Format (Cartesian Perceptual Compression) - Can Python Convert / Handle Them PSKrieger 2 2,487 Nov-11-2020, 02:57 PM
Last Post: PSKrieger
  Need help implmenting if/else or case statements for option to choose file format. samlee916 1 2,021 Jul-22-2020, 06:06 PM
Last Post: Larz60+
  copy/pasting in excel WHILE keep file format zarize 0 1,971 Jun-23-2020, 03:51 PM
Last Post: zarize
  Preserve xml file format tanffn 3 3,907 Jan-03-2020, 09:35 AM
Last Post: Larz60+
  Phyton code to load a comma separated csv file in to a dict and then in to a dB mrsenorchuck 2 2,682 Nov-29-2019, 10:59 AM
Last Post: mrsenorchuck
  Please suggest python code to format DNA sequence FASTA file rajamdade 4 3,195 Oct-24-2019, 04:36 AM
Last Post: rajamdade

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020