Skip to content

Commit 1c20c00

Browse files
meatballsmeatballs
committed
Make icon placement consistent
1 parent 6093b34 commit 1c20c00

16 files changed

Lines changed: 743 additions & 36092 deletions

File tree

‎chapters/01/index.html‎

Lines changed: 38 additions & 11814 deletions
Large diffs are not rendered by default.

‎chapters/02/index.html‎

Lines changed: 84 additions & 11802 deletions
Large diffs are not rendered by default.

‎chapters/03/index.html‎

Lines changed: 107 additions & 11791 deletions
Large diffs are not rendered by default.

‎chapters/04/index.html‎

Lines changed: 101 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -41,7 +41,7 @@
4141
<div class="row mt-5 mb-3">
4242

4343
<div class="col-sm-6">
44-
<a class="btn btn-outline-primary btn-sm" href="../16/"><i class="fa fa-backward fa-fw" aria-hidden="true"></i>&nbsp;Previous</a>
44+
<a class="btn btn-outline-primary btn-sm" href="../03/"><i class="fa fa-backward fa-fw" aria-hidden="true"></i>&nbsp;Previous</a>
4545
</div>
4646

4747

@@ -57,16 +57,17 @@
5757
</div>
5858
<div class="inner_cell">
5959
<div class="text_cell_render border-box-sizing rendered_html">
60-
<h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link" href="#Let's-Create-a-Database!">&#182;</a></h1>
60+
<h1 id="Look-at-What-we-Did!">Look at What we Did!<a class="anchor-link" href="#Look-at-What-we-Did!">&#182;</a></h1>
6161
</div>
6262
</div>
6363
</div>
6464
<div class="cell border-box-sizing code_cell rendered">
6565
<div class="input">
66-
<div class="prompt input_prompt">In&nbsp;[7]:</div>
66+
<div class="prompt input_prompt">In&nbsp;[1]:</div>
6767
<div class="inner_cell">
6868
<div class="input_area">
6969
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
70+
<span class="kn">import</span> <span class="nn">pandas</span> <span class="k">as</span> <span class="nn">pd</span>
7071
<span class="n">engine</span> <span class="o">=</span> <span class="n">sa</span><span class="o">.</span><span class="n">create_engine</span><span class="p">(</span><span class="s1">&#39;sqlite:///flight.db&#39;</span><span class="p">)</span>
7172
<span class="n">connection</span> <span class="o">=</span> <span class="n">engine</span><span class="o">.</span><span class="n">connect</span><span class="p">()</span>
7273
</pre></div>
@@ -75,6 +76,102 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
7576
</div>
7677
</div>
7778

79+
</div>
80+
<div class="cell border-box-sizing code_cell rendered">
81+
<div class="input">
82+
<div class="prompt input_prompt">In&nbsp;[2]:</div>
83+
<div class="inner_cell">
84+
<div class="input_area">
85+
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">pd</span><span class="o">.</span><span class="n">read_sql</span><span class="p">(</span><span class="s1">&#39;readings&#39;</span><span class="p">,</span> <span class="n">connection</span><span class="p">)</span>
86+
</pre></div>
87+
88+
</div>
89+
</div>
90+
</div>
91+
92+
<div class="output_wrapper">
93+
<div class="output">
94+
95+
96+
<div class="output_area">
97+
98+
<div class="prompt output_prompt">Out[2]:</div>
99+
100+
101+
102+
<div class="output_html rendered_html output_subarea output_execute_result">
103+
<div>
104+
<style scoped>
105+
.dataframe tbody tr th:only-of-type {
106+
vertical-align: middle;
107+
}
108+
109+
.dataframe tbody tr th {
110+
vertical-align: top;
111+
}
112+
113+
.dataframe thead th {
114+
text-align: right;
115+
}
116+
</style>
117+
<table border="1" class="dataframe">
118+
<thead>
119+
<tr style="text-align: right;">
120+
<th></th>
121+
<th>flight</th>
122+
<th>ts</th>
123+
<th>temp</th>
124+
<th>pressure</th>
125+
<th>humidity</th>
126+
<th>accel_x</th>
127+
<th>accel_y</th>
128+
<th>accel_z</th>
129+
</tr>
130+
</thead>
131+
<tbody>
132+
<tr>
133+
<th>0</th>
134+
<td>hab1</td>
135+
<td>2015-01-01 09:00:00</td>
136+
<td>25.5</td>
137+
<td>1020</td>
138+
<td>40</td>
139+
<td>0.0</td>
140+
<td>0.0</td>
141+
<td>0.0</td>
142+
</tr>
143+
<tr>
144+
<th>1</th>
145+
<td>hab1</td>
146+
<td>2015-01-01 09:01:00</td>
147+
<td>25.5</td>
148+
<td>1019</td>
149+
<td>40</td>
150+
<td>0.0</td>
151+
<td>0.0</td>
152+
<td>0.0</td>
153+
</tr>
154+
<tr>
155+
<th>2</th>
156+
<td>hab1</td>
157+
<td>2015-01-01 09:02:00</td>
158+
<td>25.5</td>
159+
<td>1019</td>
160+
<td>41</td>
161+
<td>0.0</td>
162+
<td>0.0</td>
163+
<td>0.0</td>
164+
</tr>
165+
</tbody>
166+
</table>
167+
</div>
168+
</div>
169+
170+
</div>
171+
172+
</div>
173+
</div>
174+
78175
</div>
79176

80177

@@ -84,7 +181,7 @@ <h1 id="Let's-Create-a-Database!">Let's Create a Database!<a class="anchor-link"
84181
<div class="row mt-5 mb-3">
85182

86183
<div class="col-sm-6">
87-
<a class="btn btn-outline-primary btn-sm" href="../16/"><i class="fa fa-backward fa-fw" aria-hidden="true"></i>&nbsp;Previous</a>
184+
<a class="btn btn-outline-primary btn-sm" href="../03/"><i class="fa fa-backward fa-fw" aria-hidden="true"></i>&nbsp;Previous</a>
88185
</div>
89186

90187

‎chapters/05/index.html‎

Lines changed: 105 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -57,16 +57,17 @@
5757
</div>
5858
<div class="inner_cell">
5959
<div class="text_cell_render border-box-sizing rendered_html">
60-
<h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Table">&#182;</a></h1>
60+
<h1 id="Let's-Change-What-We-Added">Let's Change What We Added<a class="anchor-link" href="#Let's-Change-What-We-Added">&#182;</a></h1>
6161
</div>
6262
</div>
6363
</div>
6464
<div class="cell border-box-sizing code_cell rendered">
6565
<div class="input">
66-
<div class="prompt input_prompt">In&nbsp;[9]:</div>
66+
<div class="prompt input_prompt">In&nbsp;[1]:</div>
6767
<div class="inner_cell">
6868
<div class="input_area">
6969
<div class=" highlight hl-ipython3"><pre><span></span><span class="kn">import</span> <span class="nn">sqlalchemy</span> <span class="k">as</span> <span class="nn">sa</span>
70+
<span class="kn">import</span> <span class="nn">pandas</span> <span class="k">as</span> <span class="nn">pd</span>
7071
<span class="n">engine</span> <span class="o">=</span> <span class="n">sa</span><span class="o">.</span><span class="n">create_engine</span><span class="p">(</span><span class="s1">&#39;sqlite:///flight.db&#39;</span><span class="p">)</span>
7172
<span class="n">connection</span> <span class="o">=</span> <span class="n">engine</span><span class="o">.</span><span class="n">connect</span><span class="p">()</span>
7273
</pre></div>
@@ -78,25 +79,13 @@ <h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Tab
7879
</div>
7980
<div class="cell border-box-sizing code_cell rendered">
8081
<div class="input">
81-
<div class="prompt input_prompt">In&nbsp;[10]:</div>
82+
<div class="prompt input_prompt">In&nbsp;[2]:</div>
8283
<div class="inner_cell">
8384
<div class="input_area">
8485
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">sql</span> <span class="o">=</span> <span class="s2">&quot;&quot;&quot;</span>
85-
<span class="s2">CREATE TABLE readings (</span>
86-
<span class="s2"> flight VARCHAR(10) NOT NULL,</span>
87-
<span class="s2"> ts TIMESTAMP NOT NULL,</span>
88-
<span class="s2"> temp NUMERIC(3,1) NOT NULL,</span>
89-
<span class="s2"> pressure NUMERIC(4,0) NOT NULL,</span>
90-
<span class="s2"> humidity NUMERIC(3,0) NOT NULL,</span>
91-
<span class="s2"> accel_x REAL DEFAULT 0 NOT NULL,</span>
92-
<span class="s2"> accel_y REAL DEFAULT 0 NOT NULL,</span>
93-
<span class="s2"> accel_z REAL DEFAULT 0 NOT NULL,</span>
94-
95-
<span class="s2"> CONSTRAINT readings_pk PRIMARY KEY (flight, ts),</span>
96-
<span class="s2"> CONSTRAINT temp_ck CHECK (temp BETWEEN -70 AND 70),</span>
97-
<span class="s2"> CONSTRAINT pres_ck CHECK (pressure BETWEEN 0 AND 2000),</span>
98-
<span class="s2"> CONSTRAINT hum_ck CHECK (humidity BETWEEN 0 AND 100)</span>
99-
<span class="s2">)</span>
86+
<span class="s2"> UPDATE readings</span>
87+
<span class="s2"> SET humidity = 42</span>
88+
<span class="s2"> WHERE flight = &#39;hab1&#39; and humidity = 41</span>
10089
<span class="s2">&quot;&quot;&quot;</span>
10190
<span class="n">connection</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="n">sql</span><span class="p">)</span>
10291
</pre></div>
@@ -111,13 +100,109 @@ <h1 id="Create-a-Table">Create a Table<a class="anchor-link" href="#Create-a-Tab
111100

112101
<div class="output_area">
113102

114-
<div class="prompt output_prompt">Out[10]:</div>
103+
<div class="prompt output_prompt">Out[2]:</div>
115104

116105

117106

118107

119108
<div class="output_text output_subarea output_execute_result">
120-
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10c0b6518&gt;</pre>
109+
<pre>&lt;sqlalchemy.engine.result.ResultProxy at 0x10f34b208&gt;</pre>
110+
</div>
111+
112+
</div>
113+
114+
</div>
115+
</div>
116+
117+
</div>
118+
<div class="cell border-box-sizing code_cell rendered">
119+
<div class="input">
120+
<div class="prompt input_prompt">In&nbsp;[3]:</div>
121+
<div class="inner_cell">
122+
<div class="input_area">
123+
<div class=" highlight hl-ipython3"><pre><span></span><span class="n">pd</span><span class="o">.</span><span class="n">read_sql</span><span class="p">(</span><span class="s1">&#39;readings&#39;</span><span class="p">,</span> <span class="n">connection</span><span class="p">)</span>
124+
</pre></div>
125+
126+
</div>
127+
</div>
128+
</div>
129+
130+
<div class="output_wrapper">
131+
<div class="output">
132+
133+
134+
<div class="output_area">
135+
136+
<div class="prompt output_prompt">Out[3]:</div>
137+
138+
139+
140+
<div class="output_html rendered_html output_subarea output_execute_result">
141+
<div>
142+
<style scoped>
143+
.dataframe tbody tr th:only-of-type {
144+
vertical-align: middle;
145+
}
146+
147+
.dataframe tbody tr th {
148+
vertical-align: top;
149+
}
150+
151+
.dataframe thead th {
152+
text-align: right;
153+
}
154+
</style>
155+
<table border="1" class="dataframe">
156+
<thead>
157+
<tr style="text-align: right;">
158+
<th></th>
159+
<th>flight</th>
160+
<th>ts</th>
161+
<th>temp</th>
162+
<th>pressure</th>
163+
<th>humidity</th>
164+
<th>accel_x</th>
165+
<th>accel_y</th>
166+
<th>accel_z</th>
167+
</tr>
168+
</thead>
169+
<tbody>
170+
<tr>
171+
<th>0</th>
172+
<td>hab1</td>
173+
<td>2015-01-01 09:00:00</td>
174+
<td>25.5</td>
175+
<td>1020</td>
176+
<td>40</td>
177+
<td>0.0</td>
178+
<td>0.0</td>
179+
<td>0.0</td>
180+
</tr>
181+
<tr>
182+
<th>1</th>
183+
<td>hab1</td>
184+
<td>2015-01-01 09:01:00</td>
185+
<td>25.5</td>
186+
<td>1019</td>
187+
<td>40</td>
188+
<td>0.0</td>
189+
<td>0.0</td>
190+
<td>0.0</td>
191+
</tr>
192+
<tr>
193+
<th>2</th>
194+
<td>hab1</td>
195+
<td>2015-01-01 09:02:00</td>
196+
<td>25.5</td>
197+
<td>1019</td>
198+
<td>42</td>
199+
<td>0.0</td>
200+
<td>0.0</td>
201+
<td>0.0</td>
202+
</tr>
203+
</tbody>
204+
</table>
205+
</div>
121206
</div>
122207

123208
</div>

0 commit comments

Comments
 (0)