API tools faq
paste
Guest User

Untitled

a guest
Apr 20th, 2018
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.39 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "markdown",
  5. "metadata": {},
  6. "source": [
  7. "# Drawing Conclusions Using Groupby"
  8. ]
  9. },
  10. {
  11. "cell_type": "code",
  12. "execution_count": 4,
  13. "metadata": {},
  14. "outputs": [
  15. {
  16. "data": {
  17. "text/html": [
  18. "<div>\n",
  19. "<style>\n",
  20. " .dataframe thead tr:only-child th {\n",
  21. " text-align: right;\n",
  22. " }\n",
  23. "\n",
  24. " .dataframe thead th {\n",
  25. " text-align: left;\n",
  26. " }\n",
  27. "\n",
  28. " .dataframe tbody tr th {\n",
  29. " vertical-align: top;\n",
  30. " }\n",
  31. "</style>\n",
  32. "<table border=\"1\" class=\"dataframe\">\n",
  33. " <thead>\n",
  34. " <tr style=\"text-align: right;\">\n",
  35. " <th></th>\n",
  36. " <th>fixed_acidity</th>\n",
  37. " <th>volatile_acidity</th>\n",
  38. " <th>citric_acid</th>\n",
  39. " <th>residual_sugar</th>\n",
  40. " <th>chlorides</th>\n",
  41. " <th>free_sulfur_dioxide</th>\n",
  42. " <th>total_sulfur_dioxide</th>\n",
  43. " <th>density</th>\n",
  44. " <th>pH</th>\n",
  45. " <th>sulphates</th>\n",
  46. " <th>alcohol</th>\n",
  47. " <th>quality</th>\n",
  48. " <th>color</th>\n",
  49. " </tr>\n",
  50. " </thead>\n",
  51. " <tbody>\n",
  52. " <tr>\n",
  53. " <th>0</th>\n",
  54. " <td>7.4</td>\n",
  55. " <td>0.70</td>\n",
  56. " <td>0.00</td>\n",
  57. " <td>1.9</td>\n",
  58. " <td>0.076</td>\n",
  59. " <td>11.0</td>\n",
  60. " <td>34.0</td>\n",
  61. " <td>0.9978</td>\n",
  62. " <td>3.51</td>\n",
  63. " <td>0.56</td>\n",
  64. " <td>9.4</td>\n",
  65. " <td>5</td>\n",
  66. " <td>red</td>\n",
  67. " </tr>\n",
  68. " <tr>\n",
  69. " <th>1</th>\n",
  70. " <td>7.8</td>\n",
  71. " <td>0.88</td>\n",
  72. " <td>0.00</td>\n",
  73. " <td>2.6</td>\n",
  74. " <td>0.098</td>\n",
  75. " <td>25.0</td>\n",
  76. " <td>67.0</td>\n",
  77. " <td>0.9968</td>\n",
  78. " <td>3.20</td>\n",
  79. " <td>0.68</td>\n",
  80. " <td>9.8</td>\n",
  81. " <td>5</td>\n",
  82. " <td>red</td>\n",
  83. " </tr>\n",
  84. " <tr>\n",
  85. " <th>2</th>\n",
  86. " <td>7.8</td>\n",
  87. " <td>0.76</td>\n",
  88. " <td>0.04</td>\n",
  89. " <td>2.3</td>\n",
  90. " <td>0.092</td>\n",
  91. " <td>15.0</td>\n",
  92. " <td>54.0</td>\n",
  93. " <td>0.9970</td>\n",
  94. " <td>3.26</td>\n",
  95. " <td>0.65</td>\n",
  96. " <td>9.8</td>\n",
  97. " <td>5</td>\n",
  98. " <td>red</td>\n",
  99. " </tr>\n",
  100. " <tr>\n",
  101. " <th>3</th>\n",
  102. " <td>11.2</td>\n",
  103. " <td>0.28</td>\n",
  104. " <td>0.56</td>\n",
  105. " <td>1.9</td>\n",
  106. " <td>0.075</td>\n",
  107. " <td>17.0</td>\n",
  108. " <td>60.0</td>\n",
  109. " <td>0.9980</td>\n",
  110. " <td>3.16</td>\n",
  111. " <td>0.58</td>\n",
  112. " <td>9.8</td>\n",
  113. " <td>6</td>\n",
  114. " <td>red</td>\n",
  115. " </tr>\n",
  116. " <tr>\n",
  117. " <th>4</th>\n",
  118. " <td>7.4</td>\n",
  119. " <td>0.70</td>\n",
  120. " <td>0.00</td>\n",
  121. " <td>1.9</td>\n",
  122. " <td>0.076</td>\n",
  123. " <td>11.0</td>\n",
  124. " <td>34.0</td>\n",
  125. " <td>0.9978</td>\n",
  126. " <td>3.51</td>\n",
  127. " <td>0.56</td>\n",
  128. " <td>9.4</td>\n",
  129. " <td>5</td>\n",
  130. " <td>red</td>\n",
  131. " </tr>\n",
  132. " </tbody>\n",
  133. "</table>\n",
  134. "</div>"
  135. ],
  136. "text/plain": [
  137. " fixed_acidity volatile_acidity citric_acid residual_sugar chlorides \\\n",
  138. "0 7.4 0.70 0.00 1.9 0.076 \n",
  139. "1 7.8 0.88 0.00 2.6 0.098 \n",
  140. "2 7.8 0.76 0.04 2.3 0.092 \n",
  141. "3 11.2 0.28 0.56 1.9 0.075 \n",
  142. "4 7.4 0.70 0.00 1.9 0.076 \n",
  143. "\n",
  144. " free_sulfur_dioxide total_sulfur_dioxide density pH sulphates \\\n",
  145. "0 11.0 34.0 0.9978 3.51 0.56 \n",
  146. "1 25.0 67.0 0.9968 3.20 0.68 \n",
  147. "2 15.0 54.0 0.9970 3.26 0.65 \n",
  148. "3 17.0 60.0 0.9980 3.16 0.58 \n",
  149. "4 11.0 34.0 0.9978 3.51 0.56 \n",
  150. "\n",
  151. " alcohol quality color \n",
  152. "0 9.4 5 red \n",
  153. "1 9.8 5 red \n",
  154. "2 9.8 5 red \n",
  155. "3 9.8 6 red \n",
  156. "4 9.4 5 red "
  157. ]
  158. },
  159. "execution_count": 4,
  160. "metadata": {},
  161. "output_type": "execute_result"
  162. }
  163. ],
  164. "source": [
  165. "# Load `winequality_edited.csv`\n",
  166. "import pandas as pd\n",
  167. "df = pd.read_csv('winequality.csv')\n",
  168. "df.head()"
  169. ]
  170. },
  171. {
  172. "cell_type": "markdown",
  173. "metadata": {
  174. "collapsed": true
  175. },
  176. "source": [
  177. "### Is a certain type of wine associated with higher quality?"
  178. ]
  179. },
  180. {
  181. "cell_type": "code",
  182. "execution_count": 5,
  183. "metadata": {},
  184. "outputs": [
  185. {
  186. "data": {
  187. "text/plain": [
  188. "color\n",
  189. "red 5.636023\n",
  190. "white 5.877909\n",
  191. "Name: quality, dtype: float64"
  192. ]
  193. },
  194. "execution_count": 5,
  195. "metadata": {},
  196. "output_type": "execute_result"
  197. }
  198. ],
  199. "source": [
  200. "# Find the mean quality of each wine type (red and white) with groupby\n",
  201. "df.groupby(['color'])['quality'].mean()"
  202. ]
  203. },
  204. {
  205. "cell_type": "markdown",
  206. "metadata": {},
  207. "source": [
  208. "### What level of acidity receives the highest average rating?"
  209. ]
  210. },
  211. {
  212. "cell_type": "code",
  213. "execution_count": 6,
  214. "metadata": {},
  215. "outputs": [
  216. {
  217. "data": {
  218. "text/html": [
  219. "<div>\n",
  220. "<style>\n",
  221. " .dataframe thead tr:only-child th {\n",
  222. " text-align: right;\n",
  223. " }\n",
  224. "\n",
  225. " .dataframe thead th {\n",
  226. " text-align: left;\n",
  227. " }\n",
  228. "\n",
  229. " .dataframe tbody tr th {\n",
  230. " vertical-align: top;\n",
  231. " }\n",
  232. "</style>\n",
  233. "<table border=\"1\" class=\"dataframe\">\n",
  234. " <thead>\n",
  235. " <tr style=\"text-align: right;\">\n",
  236. " <th></th>\n",
  237. " <th>fixed_acidity</th>\n",
  238. " <th>volatile_acidity</th>\n",
  239. " <th>citric_acid</th>\n",
  240. " <th>residual_sugar</th>\n",
  241. " <th>chlorides</th>\n",
  242. " <th>free_sulfur_dioxide</th>\n",
  243. " <th>total_sulfur_dioxide</th>\n",
  244. " <th>density</th>\n",
  245. " <th>pH</th>\n",
  246. " <th>sulphates</th>\n",
  247. " <th>alcohol</th>\n",
  248. " <th>quality</th>\n",
  249. " </tr>\n",
  250. " </thead>\n",
  251. " <tbody>\n",
  252. " <tr>\n",
  253. " <th>count</th>\n",
  254. " <td>6497.000000</td>\n",
  255. " <td>6497.000000</td>\n",
  256. " <td>6497.000000</td>\n",
  257. " <td>6497.000000</td>\n",
  258. " <td>6497.000000</td>\n",
  259. " <td>6497.000000</td>\n",
  260. " <td>6497.000000</td>\n",
  261. " <td>6497.000000</td>\n",
  262. " <td>6497.000000</td>\n",
  263. " <td>6497.000000</td>\n",
  264. " <td>6497.000000</td>\n",
  265. " <td>6497.000000</td>\n",
  266. " </tr>\n",
  267. " <tr>\n",
  268. " <th>mean</th>\n",
  269. " <td>7.215307</td>\n",
  270. " <td>0.339666</td>\n",
  271. " <td>0.318633</td>\n",
  272. " <td>5.443235</td>\n",
  273. " <td>0.056034</td>\n",
  274. " <td>30.525319</td>\n",
  275. " <td>115.744574</td>\n",
  276. " <td>0.994697</td>\n",
  277. " <td>3.218501</td>\n",
  278. " <td>0.531268</td>\n",
  279. " <td>10.491801</td>\n",
  280. " <td>5.818378</td>\n",
  281. " </tr>\n",
  282. " <tr>\n",
  283. " <th>std</th>\n",
  284. " <td>1.296434</td>\n",
  285. " <td>0.164636</td>\n",
  286. " <td>0.145318</td>\n",
  287. " <td>4.757804</td>\n",
  288. " <td>0.035034</td>\n",
  289. " <td>17.749400</td>\n",
  290. " <td>56.521855</td>\n",
  291. " <td>0.002999</td>\n",
  292. " <td>0.160787</td>\n",
  293. " <td>0.148806</td>\n",
  294. " <td>1.192712</td>\n",
  295. " <td>0.873255</td>\n",
  296. " </tr>\n",
  297. " <tr>\n",
  298. " <th>min</th>\n",
  299. " <td>3.800000</td>\n",
  300. " <td>0.080000</td>\n",
  301. " <td>0.000000</td>\n",
  302. " <td>0.600000</td>\n",
  303. " <td>0.009000</td>\n",
  304. " <td>1.000000</td>\n",
  305. " <td>6.000000</td>\n",
  306. " <td>0.987110</td>\n",
  307. " <td>2.720000</td>\n",
  308. " <td>0.220000</td>\n",
  309. " <td>8.000000</td>\n",
  310. " <td>3.000000</td>\n",
  311. " </tr>\n",
  312. " <tr>\n",
  313. " <th>25%</th>\n",
  314. " <td>6.400000</td>\n",
  315. " <td>0.230000</td>\n",
  316. " <td>0.250000</td>\n",
  317. " <td>1.800000</td>\n",
  318. " <td>0.038000</td>\n",
  319. " <td>17.000000</td>\n",
  320. " <td>77.000000</td>\n",
  321. " <td>0.992340</td>\n",
  322. " <td>3.110000</td>\n",
  323. " <td>0.430000</td>\n",
  324. " <td>9.500000</td>\n",
  325. " <td>5.000000</td>\n",
  326. " </tr>\n",
  327. " <tr>\n",
  328. " <th>50%</th>\n",
  329. " <td>7.000000</td>\n",
  330. " <td>0.290000</td>\n",
  331. " <td>0.310000</td>\n",
  332. " <td>3.000000</td>\n",
  333. " <td>0.047000</td>\n",
  334. " <td>29.000000</td>\n",
  335. " <td>118.000000</td>\n",
  336. " <td>0.994890</td>\n",
  337. " <td>3.210000</td>\n",
  338. " <td>0.510000</td>\n",
  339. " <td>10.300000</td>\n",
  340. " <td>6.000000</td>\n",
  341. " </tr>\n",
  342. " <tr>\n",
  343. " <th>75%</th>\n",
  344. " <td>7.700000</td>\n",
  345. " <td>0.400000</td>\n",
  346. " <td>0.390000</td>\n",
  347. " <td>8.100000</td>\n",
  348. " <td>0.065000</td>\n",
  349. " <td>41.000000</td>\n",
  350. " <td>156.000000</td>\n",
  351. " <td>0.996990</td>\n",
  352. " <td>3.320000</td>\n",
  353. " <td>0.600000</td>\n",
  354. " <td>11.300000</td>\n",
  355. " <td>6.000000</td>\n",
  356. " </tr>\n",
  357. " <tr>\n",
  358. " <th>max</th>\n",
  359. " <td>15.900000</td>\n",
  360. " <td>1.580000</td>\n",
  361. " <td>1.660000</td>\n",
  362. " <td>65.800000</td>\n",
  363. " <td>0.611000</td>\n",
  364. " <td>289.000000</td>\n",
  365. " <td>440.000000</td>\n",
  366. " <td>1.038980</td>\n",
  367. " <td>4.010000</td>\n",
  368. " <td>2.000000</td>\n",
  369. " <td>14.900000</td>\n",
  370. " <td>9.000000</td>\n",
  371. " </tr>\n",
  372. " </tbody>\n",
  373. "</table>\n",
  374. "</div>"
  375. ],
  376. "text/plain": [
  377. " fixed_acidity volatile_acidity citric_acid residual_sugar \\\n",
  378. "count 6497.000000 6497.000000 6497.000000 6497.000000 \n",
  379. "mean 7.215307 0.339666 0.318633 5.443235 \n",
  380. "std 1.296434 0.164636 0.145318 4.757804 \n",
  381. "min 3.800000 0.080000 0.000000 0.600000 \n",
  382. "25% 6.400000 0.230000 0.250000 1.800000 \n",
  383. "50% 7.000000 0.290000 0.310000 3.000000 \n",
  384. "75% 7.700000 0.400000 0.390000 8.100000 \n",
  385. "max 15.900000 1.580000 1.660000 65.800000 \n",
  386. "\n",
  387. " chlorides free_sulfur_dioxide total_sulfur_dioxide density \\\n",
  388. "count 6497.000000 6497.000000 6497.000000 6497.000000 \n",
  389. "mean 0.056034 30.525319 115.744574 0.994697 \n",
  390. "std 0.035034 17.749400 56.521855 0.002999 \n",
  391. "min 0.009000 1.000000 6.000000 0.987110 \n",
  392. "25% 0.038000 17.000000 77.000000 0.992340 \n",
  393. "50% 0.047000 29.000000 118.000000 0.994890 \n",
  394. "75% 0.065000 41.000000 156.000000 0.996990 \n",
  395. "max 0.611000 289.000000 440.000000 1.038980 \n",
  396. "\n",
  397. " pH sulphates alcohol quality \n",
  398. "count 6497.000000 6497.000000 6497.000000 6497.000000 \n",
  399. "mean 3.218501 0.531268 10.491801 5.818378 \n",
  400. "std 0.160787 0.148806 1.192712 0.873255 \n",
  401. "min 2.720000 0.220000 8.000000 3.000000 \n",
  402. "25% 3.110000 0.430000 9.500000 5.000000 \n",
  403. "50% 3.210000 0.510000 10.300000 6.000000 \n",
  404. "75% 3.320000 0.600000 11.300000 6.000000 \n",
  405. "max 4.010000 2.000000 14.900000 9.000000 "
  406. ]
  407. },
  408. "execution_count": 6,
  409. "metadata": {},
  410. "output_type": "execute_result"
  411. }
  412. ],
  413. "source": [
  414. "# View the min, 25%, 50%, 75%, max pH values with Pandas describe\n",
  415. "df.describe()"
  416. ]
  417. },
  418. {
  419. "cell_type": "code",
  420. "execution_count": 11,
  421. "metadata": {
  422. "collapsed": true
  423. },
  424. "outputs": [],
  425. "source": [
  426. "# Bin edges that will be used to \"cut\" the data into groups\n",
  427. "bin_edges = [2.72, 3.11 ,3.21 ,3.32, 4.01 ] # Fill in this list with five values you just found"
  428. ]
  429. },
  430. {
  431. "cell_type": "code",
  432. "execution_count": 12,
  433. "metadata": {
  434. "collapsed": true
  435. },
  436. "outputs": [],
  437. "source": [
  438. "# Labels for the four acidity level groups\n",
  439. "bin_names = ['low' ,'medium' ,'high' ,'very high' ] # Name each acidity level category"
  440. ]
  441. },
  442. {
  443. "cell_type": "code",
  444. "execution_count": 13,
  445. "metadata": {},
  446. "outputs": [
  447. {
  448. "data": {
  449. "text/html": [
  450. "<div>\n",
  451. "<style>\n",
  452. " .dataframe thead tr:only-child th {\n",
  453. " text-align: right;\n",
  454. " }\n",
  455. "\n",
  456. " .dataframe thead th {\n",
  457. " text-align: left;\n",
  458. " }\n",
  459. "\n",
  460. " .dataframe tbody tr th {\n",
  461. " vertical-align: top;\n",
  462. " }\n",
  463. "</style>\n",
  464. "<table border=\"1\" class=\"dataframe\">\n",
  465. " <thead>\n",
  466. " <tr style=\"text-align: right;\">\n",
  467. " <th></th>\n",
  468. " <th>fixed_acidity</th>\n",
  469. " <th>volatile_acidity</th>\n",
  470. " <th>citric_acid</th>\n",
  471. " <th>residual_sugar</th>\n",
  472. " <th>chlorides</th>\n",
  473. " <th>free_sulfur_dioxide</th>\n",
  474. " <th>total_sulfur_dioxide</th>\n",
  475. " <th>density</th>\n",
  476. " <th>pH</th>\n",
  477. " <th>sulphates</th>\n",
  478. " <th>alcohol</th>\n",
  479. " <th>quality</th>\n",
  480. " <th>color</th>\n",
  481. " <th>acidity_levels</th>\n",
  482. " </tr>\n",
  483. " </thead>\n",
  484. " <tbody>\n",
  485. " <tr>\n",
  486. " <th>0</th>\n",
  487. " <td>7.4</td>\n",
  488. " <td>0.70</td>\n",
  489. " <td>0.00</td>\n",
  490. " <td>1.9</td>\n",
  491. " <td>0.076</td>\n",
  492. " <td>11.0</td>\n",
  493. " <td>34.0</td>\n",
  494. " <td>0.9978</td>\n",
  495. " <td>3.51</td>\n",
  496. " <td>0.56</td>\n",
  497. " <td>9.4</td>\n",
  498. " <td>5</td>\n",
  499. " <td>red</td>\n",
  500. " <td>very high</td>\n",
  501. " </tr>\n",
  502. " <tr>\n",
  503. " <th>1</th>\n",
  504. " <td>7.8</td>\n",
  505. " <td>0.88</td>\n",
  506. " <td>0.00</td>\n",
  507. " <td>2.6</td>\n",
  508. " <td>0.098</td>\n",
  509. " <td>25.0</td>\n",
  510. " <td>67.0</td>\n",
  511. " <td>0.9968</td>\n",
  512. " <td>3.20</td>\n",
  513. " <td>0.68</td>\n",
  514. " <td>9.8</td>\n",
  515. " <td>5</td>\n",
  516. " <td>red</td>\n",
  517. " <td>medium</td>\n",
  518. " </tr>\n",
  519. " <tr>\n",
  520. " <th>2</th>\n",
  521. " <td>7.8</td>\n",
  522. " <td>0.76</td>\n",
  523. " <td>0.04</td>\n",
  524. " <td>2.3</td>\n",
  525. " <td>0.092</td>\n",
  526. " <td>15.0</td>\n",
  527. " <td>54.0</td>\n",
  528. " <td>0.9970</td>\n",
  529. " <td>3.26</td>\n",
  530. " <td>0.65</td>\n",
  531. " <td>9.8</td>\n",
  532. " <td>5</td>\n",
  533. " <td>red</td>\n",
  534. " <td>high</td>\n",
  535. " </tr>\n",
  536. " <tr>\n",
  537. " <th>3</th>\n",
  538. " <td>11.2</td>\n",
  539. " <td>0.28</td>\n",
  540. " <td>0.56</td>\n",
  541. " <td>1.9</td>\n",
  542. " <td>0.075</td>\n",
  543. " <td>17.0</td>\n",
  544. " <td>60.0</td>\n",
  545. " <td>0.9980</td>\n",
  546. " <td>3.16</td>\n",
  547. " <td>0.58</td>\n",
  548. " <td>9.8</td>\n",
  549. " <td>6</td>\n",
  550. " <td>red</td>\n",
  551. " <td>medium</td>\n",
  552. " </tr>\n",
  553. " <tr>\n",
  554. " <th>4</th>\n",
  555. " <td>7.4</td>\n",
  556. " <td>0.70</td>\n",
  557. " <td>0.00</td>\n",
  558. " <td>1.9</td>\n",
  559. " <td>0.076</td>\n",
  560. " <td>11.0</td>\n",
  561. " <td>34.0</td>\n",
  562. " <td>0.9978</td>\n",
  563. " <td>3.51</td>\n",
  564. " <td>0.56</td>\n",
  565. " <td>9.4</td>\n",
  566. " <td>5</td>\n",
  567. " <td>red</td>\n",
  568. " <td>very high</td>\n",
  569. " </tr>\n",
  570. " </tbody>\n",
  571. "</table>\n",
  572. "</div>"
  573. ],
  574. "text/plain": [
  575. " fixed_acidity volatile_acidity citric_acid residual_sugar chlorides \\\n",
  576. "0 7.4 0.70 0.00 1.9 0.076 \n",
  577. "1 7.8 0.88 0.00 2.6 0.098 \n",
  578. "2 7.8 0.76 0.04 2.3 0.092 \n",
  579. "3 11.2 0.28 0.56 1.9 0.075 \n",
  580. "4 7.4 0.70 0.00 1.9 0.076 \n",
  581. "\n",
  582. " free_sulfur_dioxide total_sulfur_dioxide density pH sulphates \\\n",
  583. "0 11.0 34.0 0.9978 3.51 0.56 \n",
  584. "1 25.0 67.0 0.9968 3.20 0.68 \n",
  585. "2 15.0 54.0 0.9970 3.26 0.65 \n",
  586. "3 17.0 60.0 0.9980 3.16 0.58 \n",
  587. "4 11.0 34.0 0.9978 3.51 0.56 \n",
  588. "\n",
  589. " alcohol quality color acidity_levels \n",
  590. "0 9.4 5 red very high \n",
  591. "1 9.8 5 red medium \n",
  592. "2 9.8 5 red high \n",
  593. "3 9.8 6 red medium \n",
  594. "4 9.4 5 red very high "
  595. ]
  596. },
  597. "execution_count": 13,
  598. "metadata": {},
  599. "output_type": "execute_result"
  600. }
  601. ],
  602. "source": [
  603. "# Creates acidity_levels column\n",
  604. "df['acidity_levels'] = pd.cut(df['pH'], bin_edges, labels=bin_names)\n",
  605. "\n",
  606. "# Checks for successful creation of this column\n",
  607. "df.head()"
  608. ]
  609. },
  610. {
  611. "cell_type": "code",
  612. "execution_count": 14,
  613. "metadata": {},
  614. "outputs": [
  615. {
  616. "data": {
  617. "text/plain": [
  618. "acidity_levels\n",
  619. "low 5.783343\n",
  620. "medium 5.784540\n",
  621. "high 5.850832\n",
  622. "very high 5.859593\n",
  623. "Name: quality, dtype: float64"
  624. ]
  625. },
  626. "execution_count": 14,
  627. "metadata": {},
  628. "output_type": "execute_result"
  629. }
  630. ],
  631. "source": [
  632. "# Find the mean quality of each acidity level with groupby\n",
  633. "df.groupby(['acidity_levels'])['quality'].mean()"
  634. ]
  635. },
  636. {
  637. "cell_type": "code",
  638. "execution_count": 10,
  639. "metadata": {
  640. "collapsed": true
  641. },
  642. "outputs": [],
  643. "source": [
  644. "# Save changes for the next section\n",
  645. "df.to_csv('winequality_edited.csv', index=False)"
  646. ]
  647. },
  648. {
  649. "cell_type": "code",
  650. "execution_count": null,
  651. "metadata": {
  652. "collapsed": true
  653. },
  654. "outputs": [],
  655. "source": []
  656. }
  657. ],
  658. "metadata": {
  659. "kernelspec": {
  660. "display_name": "Python 3",
  661. "language": "python",
  662. "name": "python3"
  663. },
  664. "language_info": {
  665. "codemirror_mode": {
  666. "name": "ipython",
  667. "version": 3
  668. },
  669. "file_extension": ".py",
  670. "mimetype": "text/x-python",
  671. "name": "python",
  672. "nbconvert_exporter": "python",
  673. "pygments_lexer": "ipython3",
  674. "version": "3.6.3"
  675. }
  676. },
  677. "nbformat": 4,
  678. "nbformat_minor": 2
  679. }
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!