Please enable JavaScript.

Coggle requires JavaScript to display documents.

Working with CSV Files and JSON Data - Coggle Diagram

- - - - csv module comes with Python, hence we can import it
      - To read a CSV file with the csv module, first open it using the open() function
      - But instead calling the read() or readlines() method on the File object that open() returns, pass it to the csv.reader() function. This will return a reader object for you to use.
      - The most direct way to access the values in the reader object is to convert it to a plain Python list by passing it to list()
      - exapleData[0][0]
        Out[7]: '4/5/2014 13:34'
        exapleData[0][0:2]
        Out[12]: ['4/5/2014 13:34', 'Apples']
- - - - stringOfJsonData = '{"name": "Zophie", "isCat": true, "miceCaught":0, "felineIQ":null}'
        import json
        jsonDataAsPythonValue = json.loads(stringOfJsonData)
        jsonDataAsPythonValue
        {'name': 'Zophie', 'isCat': True, 'miceCaught': 0, 'felineIQ': None}
      - To translate a string containing JSON data into a Python value, pass it to the json.loads() function
    - - the json.dumps() function (which means "dump string," not "dumps") will translate a Python value into a string of JSON-formatted data
      - pythonValue = {'name': 'Zophie', 'isCat': True, 'miceCaught': 0, 'felineIQ': None}
        import json
        stringOfJsonData = json.dumps(pythonValue)
        stringOfJsonData
        '{"name": "Zophie", "isCat": true, "miceCaught": 0, "felineIQ": null}'