Skip to content

Instantly share code, notes, and snippets.

@bitliner

bitliner/pandas.md

Last active October 4, 2024 14:07
Show Gist options
  • Save bitliner/217f4162ad4160cd7c969ea73fdc591c to your computer and use it in GitHub Desktop.
Save bitliner/217f4162ad4160cd7c969ea73fdc591c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pandas.md

pandas

add column

tutors = ['William', 'Henry', 'Michael', 'John', 'Messi']
df2 = df.assign(TutorsAssigned=tutors)

OR

df2=df.assign(Discount_Percent=lambda x: x.Fee * x.Discount / 100)

create data frame

data = [10,20,30,40,50,60]
  
# Create the pandas DataFrame with column name is provided explicitly
df = pd.DataFrame(data, columns=['Numbers'])

OR

data = [['tom', 10], ['nick', 15], ['juli', 14]]
  
# Create the pandas DataFrame
df = pd.DataFrame(data, columns=['Name', 'Age'])

OR

data = {'Name': ['Tom', 'nick', 'krish', 'jack'],
        'Age': [20, 21, 19, 18]}
  
# Create DataFrame
df = pd.DataFrame(data)

filter rows

df[df.apply(lambda x: x['b'] > x['c'], axis=1)]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment