Monday, April 24, 2017

How to read tabular data using pandas

Tabular data are data that looks like a table. Data with rows and columns like excel spreadsheet.common format is tabular data

1) Need to import panda
import panda as pd

2) Read table
 by default read_table assumes that the dataset is tab seperated.

3) Run a dataset
  • By default it would add the header
  • It added the index on the left side


If the delimiters is other than tab then we need to specify the delimiter

Note : we can save it as an object
user_cols =['user_id','age','gender','occupation','zip_code']
users=pd.read_table('', sep='|',header=None,names=user_cols)

1 comment:

  1. Fast-track your data analytics and machine learning career with guaranteed placement opportunities. Most extensive, industry-approved experiential learning program ideal for future Data Scientist