Data Analysis with Python and Pandas Tutorial Introduction

Pandas is a Python module, and Python is the programming language that we're going to use. The Pandas module is a high performance, highly efficient, and high level data analysis library.

At its core, it is very much like operating a headless version of a spreadsheet, like Excel. Most of the datasets you work with will be what are called dataframes. You may be familiar with this term already, it is used across other languages, but, if not, a dataframe is most often just like a spreadsheet. Columns and rows, that's all there is to it! From here, we can utilize Pandas to perform operations on our data sets at lightning speeds.

[leooel]

For fuck sake YOUTUBE, give this man a golden youtube award, he deserves it more than all the other useless youtubers out there!
cheers Sentdex

[CyborgGaming]

For people not being able to follow this tutorial because morningstar doesn't work anymore, here's what you'll do:
1. in cmd type: pip3 install iexfinance
2. in imports add : from iexfinance.stocks import get_historical_data
3. instead of: df = web.DataReader("XOM", "morningstar", start, end)
put: df = get_historical_data("XOM", start, end, output_format='pandas')
4. delete: df = df.drop("Symbol", axis=1)
Here we are just using iexfinance instead of morningstar(be careful tho, iexfinance can only pull the data 5 years behind, so we cannot call 2010 like he did)
Hope that helps :)

[awaraamin]

I would like to say thank you so much for all great videos you have made so far!

[preferential]

YES! I've found you to be the most reliable, easy to understand source of Python tutorials, and I was JUST wondering if you were going to do a more up-to-date Python/Pandas tutorial. THANK YOU!

[sadiqueshamim]

Your tutorials on python is the best tutorial available on internet.

[slax]

I started watching your videos to learn Python Pandas and I love it. I will watch all of them. Thank you for teaching Pandas very easily. I will tell all my friends.

[MrVnelis]

You have no idea how much your videos helped me. You made the best video tutorials that I've seen so far, thank you so much!

[ENESKEMALERGIN]

Amazing! please continue the amazing work. I love your tutorials and I am so excited about this series...

[sudheerrao]

Hey mate, i found your video series very helpful. I was trying to learn python via multiple MOOCs but i was not getting what i really needed. When I searched for a specific topic (google+video), i was guided to your youtube. Now, I have started to learn from your video series. you are doing a great job ! Thank you !

[dkwroot]

This doesn't work anymore. Even if you change import pandas.io.data to import pandas_datareader.data you'll get an error that says "data_source='Yahoo' is not implemented". If you check the pandas github, it says they deprecated Yahoo! due to changes in the api.

[mvskoushik]

ImportError: C extension: DLL load failed while importing conversion: %1 is not a valid Win32 application. not built. If you want to import pandas from the source directory, you may need to run 'python setup.py build_ext --inplace --force' to build the C extensions first

please help me guys I cant use pandas

[probabilityfilter]

For those who are unable to use "pip install pandas" or "C:/Python34/Scripts/pip install pandas" or getting an error "'pip' is not recognized as an internal or external go search for a file named "pip.exe" which will be in a folder named "Scripts" and use that path to "/pip install pandas".
In my case (Python 3.6) I had to use install pandas" where XXXX will be your login name or profile name

[abhilashsrivastava]

the pandas.io.data module has been removed
instead its pandas_datareader module now

[elmirach]

Morningstar doesnt work anymore "raise

Morningstar has been immediately deprecated due to large breaks in the API without the
introduction of a stable replacement. Pull Requests to re-enable these data
connectors are welcome."

[karlduckett]

Thanks man, still keep coming back to your tutorials! Appreciate it! Please keep up the amazing work!

[СергейГалиуллин-пю]

Just a note on Python and speed:
there are compilers (!) for Python like
nuitka and shed skin, which are meant to speed up things. It is very convenient to use them to compile some calculation-heavy parts of code and then include them to your Python code as C modules.

[maighter]

just became a BI developer, sweet! gonna continue with this on my day off tomorrow God willing

[jerome_david]

Hey Sentdex! Thanks for all your work on these videos -- I'm excited for future tutorials! Have you worked with R? I'm curious to know what benefits Python has over R for this type of work, as I'm new to Python but have some experience with R.

[azurbizzz]

I just want you to know that I aporeciate you and what you are doing here. You are a true example of a good man.

[toastersman]

I have the following error:

mysql-connector-python 8.0.11 requires protobuf>=3.0.0, which is not installed.

Any idea how to solve this? I think pip installed a lower version because of this.