- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Python - Add a zero column to Pandas DataFrame
To add a zero column to a Pandas DataFrame, use the square bracket and set it to 0. At first, import te required library −
import pandas as pd
Create a DataFrame with 3 columns −
dataFrame = pd.DataFrame(
{
"Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6]
}
)Create a new column with zero entries −
dataFrame['ZeroColumn'] = 0
Example
Following is the code −
import pandas as pd
# Create DataFrame
dataFrame = pd.DataFrame(
{
"Student": ['Jack', 'Robin', 'Ted', 'Marc', 'Scarlett', 'Kat', 'John'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'],"Roll Number": [ 5, 10, 3, 8, 2, 9, 6]
}
)
print"DataFrame ...
",dataFrame
dataFrame['ZeroColumn'] = 0
print"
Updated DataFrame ...
",dataFrameOutput
This will produce the following output −
DataFrame ... Result Roll Number Student 0 Pass 5 Jack 1 Fail 10 Robin 2 Pass 3 Ted 3 Fail 8 Marc 4 Pass 2 Scarlett 5 Pass 9 Kat 6 Pass 6 John Updated DataFrame ... Result Roll Number Student ZeroColumn 0 Pass 5 Jack 0 1 Fail 10 Robin 0 2 Pass 3 Ted 0 3 Fail 8 Marc 0 4 Pass 2 Scarlett 0 5 Pass 9 Kat 0 6 Pass 6 John 0
Updated on 21-Sep-2021 07:26:20
- Related Questions & Answers
- Python - Add a prefix to column names in a Pandas DataFrame
- Python - Add a new column with constant value to Pandas DataFrame
- How to add column from another DataFrame in Pandas?
- Python - How to select a column from a Pandas DataFrame
- Apply uppercase to a column in Pandas dataframe in Python
- Python Pandas - Subset DataFrame by Column Name
- Python - Stacking a multi-level column in a Pandas DataFrame
- Python – Create a new column in a Pandas dataframe
- Apply uppercase to a column in Pandas dataframe
- How to delete a column from Pandas DataFrame
- Adding a new column to existing DataFrame in Pandas in Python
- Adding a new column to an existing DataFrame in Python Pandas
- Python - Move a column to the first position in Pandas DataFrame?
- How to delete a column from a Pandas DataFrame?
- How to sort a column of a Pandas DataFrame?
Advertisements