Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "cells": [
- {
- "cell_type": "code",
- "execution_count": 1,
- "metadata": {
- "collapsed": true
- },
- "outputs": [],
- "source": [
- "import pandas as pd\n",
- "data = pd.read_csv('users.csv') # pd.read_table('users.csv', sep=',')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 2,
- "metadata": {},
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>id</th>\n",
- " <th>first_name</th>\n",
- " <th>last_name</th>\n",
- " <th>email</th>\n",
- " <th>gender</th>\n",
- " <th>ip_address</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>0</th>\n",
- " <td>1</td>\n",
- " <td>Anstice</td>\n",
- " <td>Sincock</td>\n",
- " <td>asincock0@wufoo.com</td>\n",
- " <td>Female</td>\n",
- " <td>124.76.249.59</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>1</th>\n",
- " <td>2</td>\n",
- " <td>Lethia</td>\n",
- " <td>Timmens</td>\n",
- " <td>ltimmens1@sourceforge.net</td>\n",
- " <td>Female</td>\n",
- " <td>14.193.225.111</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2</th>\n",
- " <td>3</td>\n",
- " <td>Carolin</td>\n",
- " <td>Hallybone</td>\n",
- " <td>challybone2@goo.ne.jp</td>\n",
- " <td>Female</td>\n",
- " <td>17.45.122.149</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3</th>\n",
- " <td>4</td>\n",
- " <td>Ad</td>\n",
- " <td>Brewitt</td>\n",
- " <td>abrewitt3@wsj.com</td>\n",
- " <td>Male</td>\n",
- " <td>117.68.14.35</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>4</th>\n",
- " <td>5</td>\n",
- " <td>Mariele</td>\n",
- " <td>Mount</td>\n",
- " <td>mmount4@wp.com</td>\n",
- " <td>Female</td>\n",
- " <td>215.176.15.211</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>5</th>\n",
- " <td>6</td>\n",
- " <td>Dave</td>\n",
- " <td>Rowney</td>\n",
- " <td>drowney5@google.fr</td>\n",
- " <td>Male</td>\n",
- " <td>217.248.75.59</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>6</th>\n",
- " <td>7</td>\n",
- " <td>Base</td>\n",
- " <td>Birkin</td>\n",
- " <td>bbirkin6@tamu.edu</td>\n",
- " <td>Male</td>\n",
- " <td>4.253.91.17</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>7</th>\n",
- " <td>8</td>\n",
- " <td>Ansell</td>\n",
- " <td>Trow</td>\n",
- " <td>atrow7@princeton.edu</td>\n",
- " <td>Male</td>\n",
- " <td>77.188.159.187</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>8</th>\n",
- " <td>9</td>\n",
- " <td>Joyann</td>\n",
- " <td>Gripton</td>\n",
- " <td>jgripton8@quantcast.com</td>\n",
- " <td>Female</td>\n",
- " <td>42.221.170.135</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>9</th>\n",
- " <td>10</td>\n",
- " <td>Felipa</td>\n",
- " <td>Kerwen</td>\n",
- " <td>fkerwen9@patch.com</td>\n",
- " <td>Female</td>\n",
- " <td>26.181.115.43</td>\n",
- " </tr>\n",
- " </tbody>\n",
- "</table>\n",
- "</div>"
- ],
- "text/plain": [
- " id first_name last_name email gender ip_address\n",
- "0 1 Anstice Sincock asincock0@wufoo.com Female 124.76.249.59\n",
- "1 2 Lethia Timmens ltimmens1@sourceforge.net Female 14.193.225.111\n",
- "2 3 Carolin Hallybone challybone2@goo.ne.jp Female 17.45.122.149\n",
- "3 4 Ad Brewitt abrewitt3@wsj.com Male 117.68.14.35\n",
- "4 5 Mariele Mount mmount4@wp.com Female 215.176.15.211\n",
- "5 6 Dave Rowney drowney5@google.fr Male 217.248.75.59\n",
- "6 7 Base Birkin bbirkin6@tamu.edu Male 4.253.91.17\n",
- "7 8 Ansell Trow atrow7@princeton.edu Male 77.188.159.187\n",
- "8 9 Joyann Gripton jgripton8@quantcast.com Female 42.221.170.135\n",
- "9 10 Felipa Kerwen fkerwen9@patch.com Female 26.181.115.43"
- ]
- },
- "execution_count": 2,
- "metadata": {},
- "output_type": "execute_result"
- }
- ],
- "source": [
- "data"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": null,
- "metadata": {
- "collapsed": true
- },
- "outputs": [],
- "source": []
- }
- ],
- "metadata": {
- "kernelspec": {
- "display_name": "Python 3",
- "language": "python",
- "name": "python3"
- },
- "language_info": {
- "codemirror_mode": {
- "name": "ipython",
- "version": 3
- },
- "file_extension": ".py",
- "mimetype": "text/x-python",
- "name": "python",
- "nbconvert_exporter": "python",
- "pygments_lexer": "ipython3",
- "version": "3.6.3"
- }
- },
- "nbformat": 4,
- "nbformat_minor": 2
- }
Add Comment
Please, Sign In to add comment