Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed CSV and JSON in Python!
You have completed CSV and JSON in Python!
Preview
JSON is quickly becoming the de facto standard for Web-based communication. Most APIs expect, accept, and return JSON and many pieces of desktop software use JSON for configuration files. Let's see how to use Python's built-in `json` module to read and write this handy format.
Python's json module has great documentation.
For both CSV and JSON files, and others, the amazing tablib library is a great thing to check out.
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
CSVs were and still are a very
popular format for importing and
0:00
exporting data to and
from databases and spreadsheets.
0:04
Much of the web though,
runs on another common and
0:08
popular format, JSON, or
JavaScript Object Notation.
0:10
No, I'm not trying to get
you to write JavaScript,
0:14
Python's JSON module is very handy for
encoding and decoding data from JSON.
0:18
You'll use this when you're
receiving information in your API or
0:23
sending information to an API, or
maybe you just want to use it to read and
0:26
write files on your server.
0:30
JSON is pretty common for
0:31
configuration files too,
regardless of how you're going to use it,
0:32
it's a great format to know about, and
a great library to know how to use.
0:36
Python's JSON library is pretty solid and
I think, pretty easy to use.
0:41
Let's check out this JSON
file about a piece of art
0:45
that I downloaded from
the Minneapolis Institute of Art.
0:49
You can see that a lot of stuff in here,
I can read it like it's a dictionary and
0:52
go, it's dated 1899, cool,
but I don't wanna do that.
0:56
I wanna be able to do this in Python,
right?
1:00
So I'm gonna make a new file and
I'm gonna call this art.py,
1:03
and inside of here, first things first.
1:09
We need to import the JSON module, so
1:11
the JSON module has all of
our handy dandy stuff in it.
1:14
So I'm going to open it up, what is this?
1:18
148.json as art file.
1:20
So I'm gonna open that up and
I'm gonna say art = jason.load(artfile),
1:25
and then I'm gonna
print(art['description']).
1:32
All right, cool?
1:38
So let's go run this.
1:40
And I get that it's a boat with two masts
in front of a bridge with a lift-gate,
1:45
two row boats in water at left,
buildings at left, trees at right,
1:49
that's the description I
got from the JSON file.
1:52
Now that might not look like much but it's
really handy if you're dealing with tons
1:55
of input from an outside source, or
lots and lots and lots of files.
1:58
And you don't have to try and
turn plain-text files in Python Objects or
2:02
anything like that through RegX or
some sort of, I don't even know,
2:08
some sort of arcane incantation.
2:12
The load method, which we used right here,
takes a file-like object and
2:15
tries to turn that into
a Python object of some kind.
2:21
In this case, because what we have here is
what we would call a dictionary in Python,
2:26
it just creates a dictionary,
it creates an actual Python dictionary.
2:31
If we had a list, an array for
JavaScript, then we would get a list
2:35
in Python, another way that we can
do this is with the load s method.
2:41
You'll probably hear people call
it loads instead of load s or
2:45
load string, I call it loads all the time.
2:48
Honestly, that's fine, that's what the
word is, but the way that it's spelled,
2:52
what it is, is it's the way that we can
take a string with embedded JSON in it and
2:56
turn that into a Python object.
3:01
Let's try that out,
let's try it out down here in the shell.
3:04
We'll do Python, import json and
3:06
let's do nums = json.loads and
3:10
then a string of 1,2, and 3.
3:14
All right, and so
now if I do nums[2] I get the number 3,
3:18
so we loaded the string in the JSON.
3:24
In that string there was an array of
integers which the JSON module turned
3:27
into a list of ints and
I think that's pretty handy.
3:31
The opposite of load and
loads are the dump and
3:36
dumps methods, so let's try them out.
3:41
So we can do json.dumps([5, 4, 3, 2, 1]).
3:45
No quote marks, and now, I get a string
which has the array of numbers in it,
3:52
so it's kinda like I turned
the list into a string,
3:57
I mean, it almost seems like I get
to str and then the list, right?
4:00
And I could on something this simple,
but on something that's a little bit
4:05
more complicated, you obviously
can't do that, let's try this.
4:08
I'm gonna make myself into a dictionary,
so first_name is Kenenth,
4:11
last_name is Love, and
my topic here at Treehouse Is Python.
4:17
All right, so I can't just do str(me),
4:24
I mean, I can but I don't get
exactly the right thing, right?
4:28
So let's do json.dumps(me) and
4:33
while it looks the same,
there is a difference because in JSON
4:37
you have to have double quotes instead
of single quotes to make it valid.
4:40
So this is valid JSON, what I did
before is not, and if I was to have
4:45
numbers like that in there, we'd want
to change how those things worked.
4:49
We could also easily send this string out
across the internet with no problems, so
4:52
that's great,
4:57
that's super handy, we could do something
similarly using the Dump method.
4:57
But Dump goes directly into a file-like
object instead of into a string,
5:02
so we have me, let's make Craig.
5:08
So again, do first_name as Craig,
5:11
last_name as Dennis, and
topic as Java all right?
5:16
So we have me, and we have Craig,
and let's do with open
5:24
teachers.json, and a for append,
although it doesn't really matter,
5:28
cuz we're writing into this for
the first time, as teacherfile.
5:34
Then we wanna say json.dump, and
5:39
we're gonna dump an array of me and
5:43
craig into teacherfile, all right?
5:47
Let that run and now,
let's shrink that down, refresh this,
5:52
if we checked out teachers.json
that the file that we just created.
6:02
There's me, and
I misspelled my own name, and
6:08
there's Craig, and
it made a list of objects.
6:12
So that's pretty cool, that's super
awesome, the JSON module is amazingly
6:17
handy for both encoding and decoding
data to and from files and strings.
6:22
I find myself using it a lot with
various APIs on the web, and
6:27
I bet that you will find it the same.
6:30
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up