Pandas with Python 2.7 Part 3 - Reading from and saving to CSV

Greetings and welcome to Part 3 of our Pandas tutorial series with Python 2.7. In this video, we cover reading from a CSV as well as writing to a CSV file. CSV files are very popularly requested to be read, so it only makes sense that Pandas makes this easy for us. Not only is reading and writing with CSV files easy in Pandas, but manipulating them as objects is easy and very powerful.

Bitcoin donations: 1GV7srgR4NJx4vrk7avCmmVQQrqmv87ty6

[californiaesnuestra]

Great job, some of the best tutorials in Youtube.

[awkb]

this was a good class. i just started using pandas this 3 months ago. But i started with python like a year ago on and off. I'm buildling my first real project. so learning a lot of practical code and not "codecademy" stuff haha. thanks!

[BenPrindle]

Thank you! This is exactly what I needed.

[imtheevil]

The sub-package pandas.io.data was deprecated in v.0.17 and removed in v.0.19. Instead there has been created a separately installable pandas-datareader package. This will allow the data modules to be independently updated on your pandas installation.

[appolizer]

Thanks very interesting video. Thank you 

[wmxjkgo]

how can you write with
an outlook on the keyboard??? u r amazing

[flakitog]

+sentdex, "start" and "end" don't work using the pd.read_csv function. Maybe it works only with data.get_data_yahoo function... is it right?

[punittewani]

Hi sentdex How can I use data time both as index as I am working with 1 minute data

[rohanmanek]

Hi, amazing tutorials. Just a question, how do you know the SP 500 ticker value? How do you take data also from other tickers or share prices?

[appolizer]

I have a large amounts of excel files with some explanations in top and bottom of data frame. I need some data with the header, do you have any videos for reading and writing data from excel files using Python or pandas? 

[geekworld]

I executed same code usingpycharm it fail to execute, also tried with notepad++ error ;UnicodeDecodeError: 'utf-8' codec can't decode byte 0xdb in position 1: invalid continuation byte

[tushargoyal]

hi sentdex, i m getting error in import pandas.io.data how to remove it and i m using spyder

[TheNotoriousPhD]

Hi. thanks for uploading this video. 
JUST A  quick one. Do you have to specify something like XXX=csv.reader(csvfile, delimiter=', ') when you import CSV data ???

[TheNotoriousPhD]

Hi sentdex , another quick question. In my perception, Pandas is a good tool for data analysis. But if I want to some data manipulation (e.g. filling the missing value or deleting some data), do I have to stick with Pandas ? Thanks

[nathanwine]

I have a quick general python question. Is there a reason that people often import a whole package and then reference something specific in that package like you do with DataFrame here? My guess is performance but I'm not really sure how it works.. Is the specific object import acting as a filter on the package? Thanks for all your effort, so much quality content on your site.

[SaeedAhmed-ixnm]

I have a question dont we have to give full path for the file? I have a file on the desktop but i cant access it.

[rajatjain]

please let me know which editor you are using to create code and how to connect it to pandas....reply must

[sandlermike]

Hi friend, thanks for this strong videos. I am using python 3, and I tried to insert my csv file same like the tutorial, but I always get this message "invalid syntax". In addition a red highlight appeared on the word "df" in this part (print df.head()).

I would highly appreciate any assistance. Thanks.

Here are the codes that I used:

import pandas as pd
from pandas import DataFrame

import datetime
import pandas.io.data

df = pd.read_csv('My file.csv')
print df.head()

[imtheevil]

Hi sentdex Are python programmers able to make a lot money?

[hotmandead]

How do I read a local csv file using pandas?