[Python Basics] How To Handle Data For This Project?

[digitalmatic7]

Hey guys,

I'm working on a project where I need to post data to a website.

I need to manage multiple sets of the following data:

• Title
  
• Description (multi-line string)
  
• Price
  

I'm thinking about making one folder per set of data so for example:

Folder 1
Title.txt
Description.txt
Price.txt

Folder 2
Title.txt
Description.txt
Price.txt

Folder 3
Title.txt
Description.txt
Price.txt

There will be an image or two in each folder.

I might go with a single CSV file vs. the text files, I want to keep it super simple though.

What's an efficient and uncomplicated way to store this data in Python where I can easily loop through it to pull what I need?

PS - I don't need any code, just the knowledge of how to move forward. Cheers!

[metulburr]

I would just use JSON. Its basically a python dictionary. Then you can load it and loop through it quite easy. You can also look at the database as well as change it on the fly if needed since its human readable.

[digitalmatic7]

I would just use JSON. Its basically a python dictionary. Then you can load it and loop through it quite easy. You can also look at the database as well as change it on the fly if needed since its human readable.

Can I process plain text with JSON? From what I saw looking at some tutorials, it looks like the text needs to have the JSON dictionary format to be processed, is that right?



Ideally I'd like to avoid having any syntax in the text files because the bot will be used by non-tech users.

I stumbled across an objects / classes tutorial that seems like it might work. Is that a viable alternative?

[digitalmatic7]

I figured out how to convert CSV to JSON:

json.dumps(list(csv.reader(open('file.csv'))))

And .txt file to JSON:

(json.dumps(list(open('file.txt')))

I don't understand how I would have a multi-line string of text since it can't be done in a CSV cell, and if I do multiple lines in a .txt file JSON parses those lines as separate values.

Do I need to merge the lines within Python?


~~~~~~~~~~~~~~~
UPDATE: I think I figured it out, thanks again for putting me onto JSON, good call!
~~~~~~~~~~~~~~~