Colab

```import pandas

</div>

</div>



<div markdown="1" class="cell code_cell">
<div class="input_area" markdown="1">
```df = pandas.read_csv('downloads/train.csv')
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
0 1 0 3 Braund, Mr. Owen Harris male 22.0 1 0 A/5 21171 7.2500 NaN S
1 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Th... female 38.0 1 0 PC 17599 71.2833 C85 C
2 3 1 3 Heikkinen, Miss. Laina female 26.0 0 0 STON/O2. 3101282 7.9250 NaN S
3 4 1 1 Futrelle, Mrs. Jacques Heath (Lily May Peel) female 35.0 1 0 113803 53.1000 C123 S
4 5 0 3 Allen, Mr. William Henry male 35.0 0 0 373450 8.0500 NaN S

```df = pandas.read_csv(‘python.csv’)

</div>

</div>



<div markdown="1" class="cell code_cell">
<div class="input_area" markdown="1">
```df
name money in bank now salary
0 eric idle 10000 5000
1 terry gilliam 2500 12500
2 graham chapman -5000 20000 


<class 'pandas.core.frame.DataFrame'>
RangeIndex: 3 entries, 0 to 2
Data columns (total 3 columns):
name                 3 non-null object
money in bank now    3 non-null int64
salary               3 non-null int64
dtypes: int64(2), object(1)
memory usage: 152.0+ bytes

```df[‘cash’] = df[‘salary’] + df[‘money in bank now’]

</div>

</div>



<div markdown="1" class="cell code_cell">
<div class="input_area" markdown="1">
``` df.columns


Index(['name', 'money in bank now', 'salary', 'cash'], dtype='object')
name money in bank now salary cash
0 eric idle 10000 5000 15000
1 terry gilliam 2500 12500 15000
2 graham chapman -5000 20000 15000

```df2 = df.drop([‘salary’, ‘money in bank now’], axis=1)

</div>

</div>



<div markdown="1" class="cell code_cell">
<div class="input_area" markdown="1">
```print(df2)


             name   cash
0       eric idle  15000
1   terry gilliam  15000
2  graham chapman  15000
name cash
0 eric idle 15000
1 terry gilliam 15000
2 graham chapman 15000 


<matplotlib.axes._subplots.AxesSubplot at 0x1f209386748>

png

```df.plot.hist(x=’Fare’, bins=50)

</div>

<div class="output_wrapper" markdown="1">
<div class="output_subarea" markdown="1">


{:.output_data_text}

<matplotlib.axes._subplots.AxesSubplot at 0x1f209692828>



</div>
</div>
<div class="output_wrapper" markdown="1">
<div class="output_subarea" markdown="1">

{:.output_png}
![png](../../images/07_files/notebooks/pandas_and_csv_14_1.png)

</div>
</div>
</div>



<div markdown="1" class="cell code_cell">
<div class="input_area" markdown="1">
```df.head()
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
0 1 0 3 Braund, Mr. Owen Harris male 22.0 1 0 A/5 21171 7.2500 NaN S
1 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Th... female 38.0 1 0 PC 17599 71.2833 C85 C
2 3 1 3 Heikkinen, Miss. Laina female 26.0 0 0 STON/O2. 3101282 7.9250 NaN S
3 4 1 1 Futrelle, Mrs. Jacques Heath (Lily May Peel) female 35.0 1 0 113803 53.1000 C123 S
4 5 0 3 Allen, Mr. William Henry male 35.0 0 0 373450 8.0500 NaN S