3.3) Pandas: Reading Excel Files in Google Colab

1.1) Why Python?

1.2) Why run Python code in Google Colab?

1.3) Why learn Python in DataCamp?

1.4) Why learn Python in Dataquest?

1.5) Introduction to Markdown in Google Colab

1.6) Learn Latex in Google Colab

1.7) Upload Data in Github to Open in Google Colab

2.1) NumPy: Data Types

2.2) NumPy: Creating Array

2.3) NumPy: Increment Operator

2.4) NumPy: Mean, Standard Deviation

3.1) Pandas: Introduction to Series

3.2) Pandas: DataFrame

3.3) Pandas: Reading Excel Files in Google Colab

3.4) Pandas: Reading CSV or Text Files in Google Colab

3.5) Pandas: Merging Dataframes

3.6) Pandas Concatenate or Append Function

3.7) Pandas: Pivoting from "Long" to "Wide" Format

3.8) Pandas: Mean of a Variable with Conditions

3.9) Pandas: Recode Categorical Variable

3.10) Pandas: Filter Columns and Rows

3.11) Load Excel/CSV Files into Google Colab

3.12) Series vs Dataframe vs MultiIndex (Panel)

4.1) Matplotlib: Introduction

4.2) Matplotlib: Boxplot and Histogram

4.3) Matplotlib: Scatterplot

4.4) Matplotlib: Figure vs Axis

5.1) Plotly: Dynamic Scatterplot with Clusters

5.2) Plotly: Dynamic Histogram with Vertical Line

5.3) Plotly: Bar Chart

6.1) Python: Function, Conditional Statement, Data Transformation

6.2) Python: Loop over List, String, Dictionary, and Numpy Array

6.3) Fibonacci: Recursion vs Loop

6.4) Python: Loop to Simulate Coin Tosses

6.5) Python Loop, List Comprehension, and Lambda Function

6.6) Python: *args vs **kwargs

6.7) What the Arrow Means in Python Function Definition?

7.1) Everything in Python is an Object

7.2) Learn How to Create a Class in Python

8.1) DataCamp Signal Assessment: Python Programming

[farahkaddoura]

Thank you for making this simple and clear to understand!

[srishicruz]

Truly, so much indepth as well as informative

[waleedsharkas]

This is a very helpful video, i am looking forward to uploading some of my own excel files and utilizing pandas and working through them.

[tchill]

Thank you for this video! It was very well explained.

[TerryTraylor-toik]

Awesome, in depth, and concise. fantastic work!

[riviera]

Thanks a to you....Was in the middle of ocean to solve this problem of importing and reading from excel, only to land up in this supercool video of yours, truly you are a genius.

[mzareer]

great video and to the point thank you

[AD-kviu]

Thanks so much for this video . I have spent so many hours unsuccessfully but finally

[lilitohanyan]

The best video of reading Excel file. Thanks!!!

[Juzz_RSA]

Thank you, finally it worked, I liked and subscribed...

[joseluisbeltramone]

Thank you very much. You saved my day today :-)

[imaduddinfarih]

hello Python for Econometrics.
i've tried your tutorial, but got MessageError: RangeError: Maximum call stack size exceeded. so what is the problem ?

thank you

[fayezsalame]

Is IO required only with Excel sheets? Or are there any other types of data frames that need IO?

[luisealcock]

Is it possible to follow a similar process for importing a Google Sheets file or does it have to be converted to an Excel file first?

[Gibbon]

whenever i try this the terminal says module 'io' has no attribute 'bytesIO' do you have any fixes

[mariaeugeniarey]

How about when I want to import a specific sheet from an Excel file? Tried the following: df = pd.read_excel(io.BytesIO(uploaded['data.xlsx', sheet_name='Sheet2'])) but didn't work.

[nifemiadegbulugbe]

Its quite an easy procedure. Might be interesting to know why we have io.BytesIO

[mecatronicaindustrial]

Thank you, but wath about if I want to trasnlate from python to excel. I want say, the other way.

[kartafanec]

Dont work
'str' object is not callable
=(
in yupyter worked is OK

[princebahuguna]

How to open a particular sheet from a Excel workbook using similar code.