1
00:00:00,005 --> 00:00:02,007
- [Instructor] There are a few simple steps to follow

2
00:00:02,007 --> 00:00:04,009
to get set up for this course.

3
00:00:04,009 --> 00:00:07,004
You can find all of the example code for this course

4
00:00:07,004 --> 00:00:09,004
in the GitHub repository at the link

5
00:00:09,004 --> 00:00:11,003
you see here on your screen.

6
00:00:11,003 --> 00:00:14,006
To use the code, you can fork a copy of this repository

7
00:00:14,006 --> 00:00:17,001
into your own GitHub account if you have one,

8
00:00:17,001 --> 00:00:20,005
or clone the repository to your machine locally,

9
00:00:20,005 --> 00:00:25,001
or you can just download the example code as a zip file.

10
00:00:25,001 --> 00:00:27,003
The code is organized into two main folders.

11
00:00:27,003 --> 00:00:29,004
There's Finished and Start,

12
00:00:29,004 --> 00:00:34,000
and both folders are organized according to the chapter

13
00:00:34,000 --> 00:00:35,006
in the course.

14
00:00:35,006 --> 00:00:38,009
The finished folder contains all of the examples

15
00:00:38,009 --> 00:00:40,003
in their finished working state

16
00:00:40,003 --> 00:00:42,007
so you can take a look at the code for each example

17
00:00:42,007 --> 00:00:45,006
to see how they work and compare the code to your own.

18
00:00:45,006 --> 00:00:48,001
The Start folder contains all of the examples

19
00:00:48,001 --> 00:00:49,004
in their starting state,

20
00:00:49,004 --> 00:00:51,000
which is the code I will be using

21
00:00:51,000 --> 00:00:55,008
to build each example toward the finished version.

22
00:00:55,008 --> 00:00:57,000
Obviously for this course,

23
00:00:57,000 --> 00:00:59,008
you will need to have Python installed on your computer,

24
00:00:59,008 --> 00:01:02,006
and you can get it from this link.

25
00:01:02,006 --> 00:01:08,001
Just go to python.org and click on the Downloads link.

26
00:01:08,001 --> 00:01:10,005
I'm going to assume that you already have experience

27
00:01:10,005 --> 00:01:12,000
working with Python code

28
00:01:12,000 --> 00:01:14,000
and that you are comfortable with concepts

29
00:01:14,000 --> 00:01:17,002
such as functions and using modules and so on.

30
00:01:17,002 --> 00:01:19,007
You don't need to be an expert in Python,

31
00:01:19,007 --> 00:01:21,007
but this is not the course to start with

32
00:01:21,007 --> 00:01:24,009
if you are not already familiar with Python programming.

33
00:01:24,009 --> 00:01:27,000
If you need to brush up on your Python knowledge,

34
00:01:27,000 --> 00:01:30,004
there are plenty of courses here in the library to help you.

35
00:01:30,004 --> 00:01:32,006
I suggest learning Python.

36
00:01:32,006 --> 00:01:34,006
In order to successfully complete this course,

37
00:01:34,006 --> 00:01:37,001
you're going to need to have Microsoft Excel,

38
00:01:37,001 --> 00:01:39,004
or at least a program that can read Excel files,

39
00:01:39,004 --> 00:01:42,002
since we're going to be creating and working

40
00:01:42,002 --> 00:01:45,003
with Excel documents using Python.

41
00:01:45,003 --> 00:01:47,007
You will also have to make sure

42
00:01:47,007 --> 00:01:50,007
that you have a couple of Python libraries installed

43
00:01:50,007 --> 00:01:55,004
for working with Excel and spreadsheet data,

44
00:01:55,004 --> 00:01:58,003
so open up your terminal program,

45
00:01:58,003 --> 00:02:02,008
and I'm going to use the pip utility that comes with Python

46
00:02:02,008 --> 00:02:05,007
to install the libraries that we need.

47
00:02:05,007 --> 00:02:10,006
They are xlsxwriter,

48
00:02:10,006 --> 00:02:13,005
openpyxl,

49
00:02:13,005 --> 00:02:15,002
and pandas.

50
00:02:15,002 --> 00:02:16,008
So I'm going to run that command

51
00:02:16,008 --> 00:02:19,004
and, oh, whoops, it's not pip, it's pip install,

52
00:02:19,004 --> 00:02:22,003
there we go,

53
00:02:22,003 --> 00:02:24,006
and you can see that I've already got these libraries

54
00:02:24,006 --> 00:02:25,007
installed on my machine,

55
00:02:25,007 --> 00:02:27,009
so I have the conditions already satisfied.

56
00:02:27,009 --> 00:02:28,009
You should see some output

57
00:02:28,009 --> 00:02:32,000
that these are getting installed on your computer

58
00:02:32,000 --> 00:02:33,003
when you run these commands.

59
00:02:33,003 --> 00:02:35,003
That's pretty much all you need to do

60
00:02:35,003 --> 00:02:36,009
to get set up for this course.

61
00:02:36,009 --> 00:02:38,006
Go ahead and place the example files

62
00:02:38,006 --> 00:02:40,003
on your computer where you want them,

63
00:02:40,003 --> 00:02:43,003
and then fire up your favorite text editor.

64
00:02:43,003 --> 00:02:46,005
I'm going to be using Visual Studio Code,

65
00:02:46,005 --> 00:02:50,005
and Visual Studio Code is a free editor from Microsoft.

66
00:02:50,005 --> 00:02:51,006
It's a great editor.

67
00:02:51,006 --> 00:02:54,005
It has great extensions for working with Python.

68
00:02:54,005 --> 00:02:56,001
If you decide to use VS Code,

69
00:02:56,001 --> 00:02:57,009
which I highly recommend,

70
00:02:57,009 --> 00:03:02,004
install the Python extension from the VS Code Marketplace,

71
00:03:02,004 --> 00:03:03,006
and that's really easy.

72
00:03:03,006 --> 00:03:05,000
Just click on this little icon

73
00:03:05,000 --> 00:03:06,008
that looks like a bunch of boxes,

74
00:03:06,008 --> 00:03:09,000
and then do a search on the word Python.

75
00:03:09,000 --> 00:03:11,003
The very first result, this one right here,

76
00:03:11,003 --> 00:03:12,006
the one from Microsoft,

77
00:03:12,006 --> 00:03:14,003
it has hundreds of millions of downloads,

78
00:03:14,003 --> 00:03:15,004
you can't go wrong.

79
00:03:15,004 --> 00:03:16,003
This is the one you want.

80
00:03:16,003 --> 00:03:17,005
So go ahead and install that,

81
00:03:17,005 --> 00:03:19,004
and then once you've completed these steps,

82
00:03:19,004 --> 00:03:21,000
you are ready to get started.