Intro:
Aside - Slicing (Last value INCLUSIVE; df.loc[, 'col1':'col2']): 28:18
One clarification here, if you do slicing using iloc, the end index is not inclusive, that is, if you run a command df.iloc[, 1], this would return only the first 2 rows (works just like core Python). Whereas in case of loc, it returns the end index (returns all 3 rows for above example), which is very well explained by Corey.
While slicing a list index 2 is exclusive here it is inclusive
Why df.loc[,’hobbyist’] gives a series type object whereas df.loc[0:2,”hobbyist”:”country”] gives a data frame?
edit. oh, i get it now. when i use df.iloc[] i'm working on integers 0, 1 and 2 and therefore python logic of inclusive:exclusive applies. however when i'm using df.loc[0:2] i'm working on labels '0,' '1' and '2' and therefore language logic of inclusive:inclusive applies, as in "I'm working from Monday to Friday." means that i'm working on Friday as well.
i don't know if it's a bug or it's intentional (certainly it's confusing), but df.iloc[] will return you rows 0 and 1 but not 2, whereas df.loc[0:2] will return you rows 0, 1 and 2.
df.iloc[&5:10, 'a':'c'&'f':'t']
x=df.loc[,'user_id':'occupation'] #here when slicing don't speicify like [0:4] because the whole function code is changed. Here 0 and 4 are included. It is not range or slicing type we are passing. Something totally different.
What is a DataFrame?:
df.loc[, ['Employment', 'BetterLife']] #selects range 0 to 50 of employment, better lifeHow do we know when to put the brackets[..] and when to not use them?
df.loc[[], ['Employment', 'BetterLife']] #this doesn't work
.head()
What is a DataFrame
Using Dictionary to store information
Create a DataFrame from a Dictionary:
Create a DataFrame from Dictionary
Series vs DataFrames and Accessing a Single Column of Data (`.` vs `[]`):
Access a single column using brackets
- access a single column via string()
- dot notation
Hello Corey. Can you please tell us: which Object Oriented trick in python allows to use this kind of "dot" notation () for indexing? Thank you
Could you tell me how did you auto quote after selecting count word at please?Thanks
']]):
Access multiple columns using brackets
- access multiple COLUMNS- pass in a list() of the columns you want.
- access ROWS with loc and iloc -- loc is for labels, iloc is for integers.
Get Column Indices ("Headers"; `df.columns`):
- list all the columns - df.columns
How to Get Rows (`df.iloc[[row_ints,],[col_ints,]]`, `df.loc[[row_labels,],[col_labels,]]`):
- iloc
Access a single row using iloc
Access multiple rows using iloc
Access columns and rows using iloc
Access a single row using loc
Access multiple rows using loc
Access columns and rows using locPart 2: Using a Dataset
- use two lists, one for the ROWS and another, second list, for COLUMNS to get a subset of the DataFrame.
Practice on Real-World Dataset:
See all columns name
See how many rows and columns
Aside - Intro to `.value_counts()`:
Count unique values
Using slicing
4th row ... MgrIdiot :D :D
Aside - Why is Slicing Inclusive?:
