Python and Pandas for Sentiment Analysis and Investing 2 - Pandas Basics

This video tutorial is dedicated to teaching the basics of using Pandas with Python. In this example we grab stock prices from Yahoo Finance, learn how to access specific columns, how to modify columns, add columns, delete columns, and perform basic math on them.

Pandas is used to work with our data quickly and efficiently. The ideas of Pandas is to act as a sort of framework for quickly analyzing data and modeling it.

Sentiment Analysis data:

Python Module downloads:
(Get all of the listed dependencies, or at least the major ones like NumPy, Dateutils, Matplotlib, )

Bitcoin donations: 1GV7srgR4NJx4vrk7avCmmVQQrqmv87ty6

[dfrusdn]

You do not need all the date time stuff you can just do this and it works

pd.io.data.DataReader(AAPL, 'yahoo', start='01/01/2010')

for apple. The dates already use datetime there is no need to import it twice

[bboymksh]

This video really helps me to learn about Pandas. Thank you so much!

[อนรรฆวรรณภาสชัยยง]

what platform do u run your python on ? eliscpe?

[specom]

I'm having some issues, I think its because im using windows 10? I got this set up perfect on my windows 7 work laptop. But im getting 1 line error for pandas and like 6 line errors for numpy. Ive been using python 3.5 on both. Ill try python 3.4 on my windows 10 and see what happens.

For example the pandas one says something like line 13 __import__(dependencies) it seems like some compatibility issue because i did what seemed to be the exact same thing on my laptop, i tried 32 and 64 bit as well.

[Awnaji]

Thanks for sharing this bro! Very useful stuff!

[wwgg]

For Python 3 users: change 'print' to be a function -> 'print()'
Install 'pandas_datareader' module and change 'import pandas.io.data' to 'import pandas_datareader.data'

[อนรรฆวรรณภาสชัยยง]

i have error in line 3. How can i fix the error?

[Calg]

We have the same Mic! You've put some tape on that annoying light as well!

[callmeness]

I worked with python3.65 and it tells an error:
import pandas.io.data
ModuleNotFoundError: No module named 'pandas.io.data'

searching the internet to replace the problem using codes below but it does not work for me:
from pandas.core.common import is_list_like
ImportError: cannot import name 'is_list_like',

is it because the module has already removed or something?

[gloryths]

Guys the video is 4 years old. Packages mind have changed their names and Yahoo doesn't work that properly to extract data