-
Notifications
You must be signed in to change notification settings - Fork 0
/
Set-Up-Instructions-WINDOWS.txt
176 lines (105 loc) · 4.71 KB
/
Set-Up-Instructions-WINDOWS.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
## WINDOWS ##
## DETERMINE IF YOUR COMPUTER IS 32-BIT OR 64-BIT ##
1. Go to: http://windows.microsoft.com/en-us/windows7/find-out-32-or-64-bit
2. Follow the instructions to determine if your computer is 32-bit or 64-bit
## INSTALL CYGWIN ##
1. Go to: https://cygwin.com/install.html
2. If your computer is 32-bit, click the 32-bit set-up executable (e.g. setup-x86.exe)
2. If your computer is 64-bit, click the 64-bit set-up executable (e.g. setup-x86_64.exe)
3. Follow the default set-up instructions
Note: After you install Cygwin, you re-run the same setup-x86.exe or setup-x86_64.exe executable to check your installation and to add / remove items
(On the “Select Packages” page, make sure the following items are installed or will be installed. By default, they should be, but it’s good to check. Also, don’t simply try to install everything…it will take forever to install everything and you don’t need everything. Also, other items will be installed by default and that’s fine.)
Admin > cron
Base > bash
Base > cygwin
Base > gawk
Base > grep
Base > sed
Database > sqlite3
Devel (all of the default items)
Editors > emacs
Editors > nano
Editors > vim
Graphics > gnuplot
Graphics > ImageMagick
Interpreters > emacs
Interpreters > gawk
Interpreters > idle
Interpreters > perl
Interpreters > python
Math > bc
Math > lapack
Math > libopenblas
Math > R
Net > curl
Perl > perl
Python > python
Shells > bash
Shells > xterm
Utils > time
Utils > tree
## INSTALL MYSQL COMMUNITY SERVER ##
1. Go to: https://dev.mysql.com/downloads/mysql/
3. Click the "Download" button for the All-In-One MySQL Installer (e.g. Windows (x86, 32-bit), MySQL Installer MSI)
4. Double-click the downloaded application to begin the installation
5. Follow the installer's installation instructions
## INSTALL R ##
1. Go to: https://cran.r-project.org/bin/windows/base/
2. Click the top link to download the latest package version (e.g. Download R 3.2.2 for Windows)
3. Double-click the downloaded application to begin the installation
4. Follow the installer's installation instructions
## INSTALL RSTUDIO ##
1. Go to: https://www.rstudio.com/products/rstudio/download/
2. Click the link for the Windows installer (e.g. RStudio 0.99.489 - Windows Vista/7/8/10)
3. Double-click the downloaded application to begin the installation
4. Follow the installer's installation instructions
## INSTALL ANACONDA PYTHON ##
1. Go to: https://www.continuum.io/downloads#_windows
2. Click the Python 3.5 Windows Graphical Installer to download the Python 3.5 package installer
3. Double-click the downloaded application to begin the installation
4. Follow the installer's installation instructions
## INSTALL CSVKIT AND UTILITIES AND CREATE ALIASES ##
# INSTALL CSVKIT #
1. Open an iTerm or Terminal window
2. Type the following and hit Enter: conda install csvkit
# INSTALL UTILITIES #
1. Open a Cygwin window
2. Navigate to the Data-Science-with-Unix-SQL-R-Python folder by typing something like the following and hitting Enter:
cd Documents/Data-Science-with-Unix-SQL-R-Python
3. Copy all of the utilities into your usr/local/bin folder by typing something like the following and hitting Enter:
cp Utilities/* /usr/local/bin/
# Create aliases to the utilities in your .bash_profile file #
1. Open a Cygwin window
2. Type the following and hit Enter: emacs .bash_profile
3. Copy and paste the following aliases into the file:
alias body='/usr/local/bin/body'
alias csvclean='/usr/local/bin/csvclean'
alias csvcut='/usr/local/bin/csvcut'
alias csvformat='/usr/local/bin/csvformat'
alias csvgrep='/usr/local/bin/csvgrep'
alias csvjoin='/usr/local/bin/csvjoin'
alias csvjson='/usr/local/bin/csvjson'
alias csvlook='/usr/local/bin/csvlook'
alias csvpy='/usr/local/bin/csvpy'
alias csvsort='/usr/local/bin/csvsort'
alias csvsql='/usr/local/bin/csvsql'
alias csvstack='/usr/local/bin/csvstack'
alias csvstat='/usr/local/bin/csvstat'
alias in2csv='/usr/local/bin/in2csv'
alias Rio='/usr/local/bin/Rio'
alias sql2csv='/usr/local/bin/sql2csv'
4. Save and close the file by typing the following four key combinations in sequence:
control-x THEN control-s THEN control-x THEN control-c
## CHECK THAT YOU HAVE SQLITE/SQLITE3 ##
1. Open a Cygwin window
2. Type the following and hit Enter: sqlite3
You should see the SQLite version and sqlite prompt in the window
3. Type the following and hit Enter to exit sqlite: .q
## CHECK THAT YOU HAVE PERL ##
1. Open a Cygwin window
2. Type the following and hit Enter: perl -e 'print "Hello Mr Euler!\n"'
You should see Hello Mr Euler! printed to the screen
## CHECK THAT YOU HAVE AWK ##
1. Open a Cygwin window
2. Type the following and hit Enter: awk 'BEGIN { print "Hello Mr Euler!" }'
You should see Hello Mr Euler! printed to the screen