# pandas

## add column

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

OR

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

## create data frame

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

OR

```python
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)]
```