Python Pandas - Add, Delete, Split DataFrame Columns

In this python pandas programming tutorial, we will go over how to add, delete, and split dataframe columns.

[Aditya]

Great explanation with small dataframe.. keep up the god work.Specially split, string part was a huge help

[gunjanmakwana]

How to split numbersike this?
I have put 5 values in single line in vertical column. How do i split ghem in different column?

[judeleon]

Greate tutorial! Thanks. However, it could have been better if you made the print a little bigger, or zoomed in, so we can have better view of the prints

[harithameka]

Hii Ryan Noonan I have one year data in a DataFrame i just want split into a month how can i do it
the column that i Date, time, Value1, Value2

plzz reply

[simoneprovenzale]

Thanks for your video Ryan! I am just stuck while trying to create a new column in a csv file.
If I do a simple operation like you have done with existing columns

readCSV1['Intra5min Bid Dispersion']=readCSV1['High Bid']-readCSV1['Low Bid'])

I am told the following warning: "TypeError: '_csv.reader' object is not subscriptable". How can I manage that?

[utkar]

Hey thanks this was helpful!!
What does the 1 signify in the str.split code??

[ashutoshkarna]

I am trying to do something similar but instead getting a weird warning. This is what I am trying :
layer_idx = layer_table.loc[:, 'content'].str.split('layer: ').str[1].str.split(', ')
layer_table['layer_idx'] = layer_idx.str.get(0)

and this is the warning I am getting :
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer, col_indexer] = value instead

Do you know how to fix this ? The code does give the valid results though.