官术网_书友最值得收藏!

Various methods of importing data in Python

pandas is the Python library/package of choice to import, wrangle, and manipulate datasets. The datasets come in various forms; the most frequent being in the .csv format. The delimiter (a special character that separates the values in a dataset) in a CSV file is a comma. Now we will look at the various methods in which you can read a dataset in Python.

Case 1 – reading a dataset using the read_csv method

Open an IPython Notebook by typing ipython notebook in the command line.

Download the Titanic dataset from the shared Google Drive folder (any of .xls or .xlsx would do). Save this file in a CSV format and we are good to go. This is a very popular dataset that contains information about the passengers travelling on the famous ship Titanic on the fateful sail that saw it sinking. If you wish to know more about this dataset, you can go to the Google Drive folder and look for it.

A common practice is to share a variable description file with the dataset describing the context and significance of each variable. Since this is the first dataset we are encountering in this book, here is the data description of this dataset to get a feel of how data description files actually look like:

Note
VARIABLE DESCRIPTIONS:
pclass          Passenger Class
                (1 = 1st; 2 = 2nd; 3 = 3rd)
survival        Survival
                (0 = No; 1 = Yes)
name            Name
sex             Sex
age             Age
sibsp           Number of Siblings/Spouses Aboard
parch           Number of Parents/Children Aboard
ticket          Ticket Number
fare            Passenger Fare
cabin           Cabin
embarked        Port of Embarkation
                (C = Cherbourg; Q = Queenstown; S = Southampton)
boat            Lifeboat
body            Body Identification Number
home.dest       Home/Destination

The following code snippet is enough to import the dataset and get you started:

 import pandas as pd
 data = pd.read_csv('E:/Personal/Learning/Datasets/Book/titanic3.csv')
主站蜘蛛池模板: 施秉县| 长治市| 柏乡县| 夏津县| 栖霞市| 泌阳县| 凭祥市| 县级市| 宝清县| 通江县| 任丘市| 望奎县| 南陵县| 峨眉山市| 定边县| 金川县| 泰顺县| 镇远县| 博野县| 通山县| 房山区| 来安县| 孟州市| 四平市| 云和县| 灯塔市| 青神县| 安塞县| 防城港市| 增城市| 微山县| 闵行区| 建昌县| 商南县| 宝丰县| 凤台县| 平顺县| 湘潭县| 广汉市| 盘锦市| 广州市|