Add & Delete

To add a new column, specify the new column name and a value dataframe:

df["new_column"] = value

value can hold a single value like "string", 5, etc; this will fill the whole column with the same value for all rows. Or it can hold a list, dictionary, or series with the same number of rows in the dataframe, like [1, 2, 3, ...].

It is not recommended to add new rows to a dataframe because it is slow. Instead, it would be better to add the data to the CSV file or the dictionary you are working with and then convert it to a dataframe.

If there is no other way, add a row to the end of the dataframe:

df.loc[len(df)] = ["string", 1, 2, ...]

There is no built-in option to insert a row into a specific index. If you'll write this:

df.loc[0] = ["string", 1, 2, ...]

It will modify the first row completely.

To delete a column, use axis=1:

df = df.drop('column_name', axis=1)
df = df.drop(['column1_name', 'column2_name'], axis=1) # Multipe columns

To delete a row, use axis=0

df = df.drop(index, axis=0)