What do I need to know about the pandas index? (Part 1)

super amazing teacher

🔥

Can I have a non unique values for index? What would happen?

SMH you are such a google instructor! :D

How do I learn all these methods man they are so many and really hard to remember

Thanks a lot for the detailed explanation. I appreciate you hard work and sharing your knowledge

You are a fantastic teacher.

Thank you for the great work. How coukd do if i have an array (suppose the score of a pca with 3 components) and i would select just the index of the elememts who respect a certain condition?

Thank you!

Great video

How you can found the index number of a row?

Silly question: How do I get the neat separation black lines in my table of the df? I only get one line below the column headers.

i love you

your video help me a lot. thank you

Amazing explanations. Thank you so much.

Hello Dear,
Respect for the the elegance , respect for the simplicity
I am Egyptian arabic speaker with good english competence,I 've started to teach some pandas videos in arabic (learn data analysis from a beginner:),
You are my role model ,
wonder if dataset links here is open source? can i use them in my videos?
Regards

wooow so glad I chose this video over others! So thorough and clear! Easy to follow! I was struggling and now my code is working. thank you.

Excelent job!! It's amazing the quality of your job!! Thanks

Perfect explanation! Even the documentation doesn't do such a good job!

Sir kindly tell me [corrmat=dataset.corr()
top_corr_features=corrmat.index]
What does .index function works and how this code working

thank you, I was stuck how to change the header of my dataset

Hi,
Thanks for your videos,
Could you make a video how to sort values from two different data frames, then store them in new data frames.
For example
data frame 1 has 2 columns name of product and column 2 the country where is made
data frame 2 has two columns which are as well product and country, but in this second data frame we will include similar few similar products and country as first data frame.
could you write a script to iterate through dataframe 1 and 2 then find the identical product , then append it to data frame 3 along with country column.

Thank you

thanks a lot. very thorough.

epic

Sir if we have hundreds of columns without the name. Then how can we name them using pandas and a for loop or lambda function because if we try to name them using names=[] it will be a very time-consuming process. The name of the columns can be col1, col2 , col3...etc.

The tip is amazing.

If I have a 3000×563 raw dataset without any column names and a list of 563 features. How can I name my columns using dataframe?

Brilliant- This made the exact function of indexes very clear - I am binge watching these videos now!

Can you post a video on creating dataframe from dictionaries nested at multiple levels

Can you please tell me how to convert strings into numbers. Word to number system.

Data School is the ultimate place to learn about Pandas.
Thanks for the excellent tutorials on Pandas.

How do you get values in the data frame when the index values are always changing? I.e every time I update my csv file the dates will be updated?

sir how can i use the default index values(i.e.0,1,2,3,4......) as one my column values. For example: I have columns such as ID, Name,Faculty. And here i want, ID column to be filled with the values of default index values(i.e 0,1,2,3,4.....).Hope for the postive response.

Thanks for being so effortless and keeping it to the base level .... it is more understandable!

You are so articulate and never give me a headache like most of the others

Am getting output like below:
drinks.index
RangeIndex(start=0, stop=193, step=1)
how to get like your output?

Have a question, drinks.head( ) getting nice table format but am not getting.
How to get with table?

You made my life easy. I am new to this language word and was struggling to understand the concepts. Your videos just saved me.

Hlo... Sr. How to convert rows into colomns nd colomns into rows in dataset

Hi I tried set_index as ' Name' it changed the rows as Name but whn I changed and again gave the same name as 'Name' to set_ index, m getting an error stating " none of [' Name'] are in the clm". Can u plz help me here

Let’s say you have column headers that contain dates and the actual data frame rows contains values specific to each date and you wish to plot each value for each date. Ultimately creating a line graph from all the values. X axis being the dates and y axis being the values. How would approach this. I’ve looked at variety of your videos but can’t seem to find a definite way of doing this.

Dude, you have best communication skills among Data Science Coaches

What happens when the column you set as the index has >1 instance of that value? Like what if there was more than one row for Country?

Thanks for the vids. What if I want to use a column as an index (like country) but I also want it to be a column in the dataset so the values can be accessed using standard access techniques (i.e. df[column], df.column, getting subsets of the data with [:], data use with .loc & .iloc, etc.). Is there a way to tell pandas to use a column as an index AND leave it as a column? Or would you have to copy the column to a new name to keep the data acessible?

"boolean arrays use the same shortcut as slices to select along the index axis"
can you please justify what the above statement means?

how to change underline data after sorting a series