How do I select a pandas Series from a DataFrame?

You are truly an amazing teacher; thank you for explaining things in such a simple manner.

u look like panda

the links for data are notloading what to do

hey Kevin! I wanted to ask how do I add two data series together if they are of different data type like one is a str and other is int . Great series btw thanks a lot!

Very Well done!

I discovered your channel, scrolling randomly to find solutions to my python problems and i'm so thankful that i found you. You teach everything in the easiest possible way. I'm new to python and datascience but it's gonna be a great journey, Thanks to u!!!!!!

Why am I getting this error 'AttributeError: 'dict' object has no attribute '_get_axis_number' when I try to do 'ufo.City' and ufo['City'] ? 😢

Awesome

how to put a comma in between city and state in this form
df['Location'] = df['City'] + df['State']

Very nice

great session

Is there any advantages of read table vs read csv?

The way you talk is Awesome

You are very good at explaining things! Thank you🙏

Thank you so much , this is one of best Pandas tutorials

Nice I got one issue in sheet 1 I have multiple data in column one cell like (1,2,3,4) many cells I have to compare them with another column in sheet 2 but sheet 2 I have only single digit number in column cell like (1) if sheet 1 matches with sheet 2 then should replace with new values which is also present in sheet 2

Really great teaching, thank you sir.

Thank you so much. This is very helpful.

Damn，Kevin, you are so good at teaching !

What if I have to go from Location to City and State. I am given Ithaca, NY and I have to separate them and make them into two columns - one containing Ithaca and other containing NY

Location was added to the end. How do we specify a different location, e.g. after City.

I run this statement to see if a new column location can be created which will contain two subcolumns city and state but it is just assigning a value of the city to the new column.
ufo["location"]=ufo[["City",'State']]

love that you can practise the same stuff you are writing and getting same results. I understand Pandas a whole lot better now

Thanks!

Sir I have a question : when I type 'ufo.' and tab, there are bunch of other parameter including column names. Is this normal?

I love the bonus tricks. On this particular trick, instead of doing the concatenation, how can I do calculation with my tabular data and display the result at the last column?

Hi, when I print out the data for cities, it only displayed the first and last 5 cities. Is there a way to show more than just that? Thanks

You are really really a good teacher. I learnt many things from u. You are the best best teacher of the word because your each word is crystal clear. Please make a video series for deep learning also.
Thanks a lot.

Thanks You, Sir. How we add new column, but it is the first column? Thanks

All your videos are great and could you plz update more videos on scipy stats and how to use all the business statistics tools in python.

Great job clearly describing commonly overlooked syntax. Learned alot.

Nice

Fine why we use .str to change column name

Sounds to me like it might be just better practice overall to use bracket notation rather than dot notation. It will just work more often.

How do I select a series from dataframe if I had a header with integer

what is the use of verbose in read_csv?

how do I import pandas in IDE, I installed the pandas file but when I write the codes there is no result

No bonus 😭

I never met a person with such a clear voice like you and also the speed you speak makes it easy for someone to understand you even if English isn't their first language. Thank you

Really like the way you explain things. Loved your every video!
Would you please do some tutorial on excel worksheets styling in Python? for example multi level header with merged cells in one level/conditional coloring/bold rows by column value... Thanks.

Can we add a series with telephone code of the cities to the data above above ufo data frame? Thanks!

You are awsome, thank you

whats the diff between ufo.head and ufo.head() ?

helloo

your series/pacing is perfect. haven't been this stoked to learn data sci

why i dont get output like this i.e. in properly formatted output with vertical and horizontal lines and data in the boxes formed

i was trying to add more column on same data frame , but somehow got struct creating new series on same frame .

when we add new column to dataframe ,does it always get added as last column?
or can we put it in between somewhere?

Great!