Add a new row to a Pandas DataFrame with specific index name
Add row with specific index name:
import pandas as pd employees = pd.DataFrame( data={'Name': ['John Doe', 'William Spark'], 'Occupation': ['Chemist', 'Statistician'], 'Date Of Join': ['2018-01-25', '2018-01-26'], 'Age': [23, 24]}, index=['Emp001', 'Emp002'], columns=['Name', 'Occupation', 'Date Of Join', 'Age']) print("\n------------ BEFORE ----------------\n") print(employees) employees.loc['Emp003'] = ['Sunny', 'Programmer', '2018-01-25', 45] print("\n------------ AFTER ----------------\n") print(employees)
C:\pandas>python example22.py ------------ BEFORE ---------------- Name Occupation Date Of Join Age Emp001 John Doe Chemist 2018-01-25 23 Emp002 William Spark Statistician 2018-01-26 24 ------------ AFTER ---------------- Name Occupation Date Of Join Age Emp001 John Doe Chemist 2018-01-25 23 Emp002 William Spark Statistician 2018-01-26 24 Emp003 Sunny Programmer 2018-01-25 45 C:\pandas>
2018-10-29T23:18:48+05:30
2018-10-29T23:18:48+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution