How to import a CSV file in pandas

read_csv_example.py

# cd to a directory with a csv file in it. Any old csv file will do.
# run ipython and type these things at the interactive prompt, line by line:

>>> import pandas as pd

>>> data = pd.read_csv('some_csv.csv')  # other arguments to read_csv are available to change the separator char, for example

>>> data

>>> data.keys  # access the keys property of the DataFrame object

>>> len(data)  # see the length of the DataFrame object

>>> data.some_column.sum()  # get the sum of numeric-type columns

>>> data.some_column.count()  # get the count of non-null values

The >>> signifies the prompt, so don't type that. For instance, on line 4, just type

import pandas as pd