- \n
- \n
- \n
- How to Add dictionary as a row to dataframe<\/a><\/li>\n
- Add Series as a row in the dataframe<\/a><\/li>\n
- How to Add row from one dataframe to another dataframe<\/a><\/li>\n
- How to Add a row in the dataframe at index position using iloc[]<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
<\/a>Pandas – Definition<\/h2>\n
Pandas is a package in python that is used to analyze data in a very easy way. The reason why pandas are so famous is that it is very easy to use. But we can not directly use the pandas’ package in our program. To use this package first we have to import it.<\/p>\n
<\/a>Dataframe – Definition<\/h2>\n
Dataframe is a 2D data structure that store or represent the data in the 2D form or simply say in tabular form. The tabular form consists of rows, columns, and actual data. By using pandas we can manipulate the data as we want i.e we can see as many columns as we want or as many rows as we want. We can group the data or filter the data.<\/p>\n
Let us understand both dataframe and pandas with an easy example<\/p>\n
import pandas as pd\r\nd={\"Name\":[\"Mayank\",\"Raj\",\"Rahul\",\"Samar\"],\r\n \"Marks\":[90,88,97,78]\r\n }\r\ndf=pd.DataFrame(d)\r\nprint(df)<\/pre>\nOutput<\/p>\n
Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78<\/pre>\n
Here we see that first, we import our pandas package then we create a dictionary, and out of this dictionary, we create our dataframe. When we see our dataframe we see that it consists of rows and columns and data. There are many ways to create a dataframe like importing excel or CSV files or through a dictionary but this is not the main concern of this article.<\/p>\n
Before understanding the concept of appending rows to a dataframe first we have to know a little bit about the append() method.<\/p>\n
<\/a>append() method<\/h3>\n
append() method is used to append rows of other dataframe at the end of the original or given dataframe. It returns a new dataframe object. If some columns are not presented in the original dataframe but presented in a new dataframe then-new column will also be added in the dataframe and data of that column will become
NAN.<\/code>
\nSyntax: DataFrame.<\/span>append<\/span>(<\/span>other, ignore_index=<\/span>False<\/span>, verify_integrity=<\/span>False<\/span>, sort=<\/span>None<\/span>)<\/span><\/p>\n<\/a>Ways on Pandas append row to Dataframe<\/h2>\n
Method 1- <\/a>How to Add dictionary as a row to dataframe<\/h3>\n
In this method, we see how we can append dictionaries as rows in pandas dataframe. It is a pretty simple way. We have to pass a dictionary in the append() method and our work is done. That dictionary is passed as an argument to
other<\/code> the parameter in the append method. Let us see this with an example.<\/p>\n![\"Add](\"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/04\/Add-dictionary-as-a-row-to-dataframe-in-Pandas.png\")
<\/p>\nd={\"Name\":[\"Mayank\",\"Raj\",\"Rahul\",\"Samar\"],\r\n \"Marks\":[90,88,97,78]\r\n }\r\ndf=pd.DataFrame(d)\r\nprint(df)\r\nprint(\"---------------\")\r\nnew_d={\"Name\":\"Gaurav\",\r\n \"Marks\":76}\r\nnew_df=df.append(new_d,ignore_index=True)\r\nprint(new_df)<\/pre>\nOutput:<\/strong><\/p>\n
\n\n\n\n\nName Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n---------------\r\n Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n4 Gaurav 76\r\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n\n\nExplanation:<\/div>\nIn this example, we see how we can append a dictionary in our original dataframe. By this method, our original dataframe will not affect that why we store the new Dataframe in a new variable so that we can analyze the changes.<\/div>\nInstead of assigning it to a new variable, we can assign it to the original dataframe in this case our original dataframe gets modify. It means that the append() method is not inplace.<\/div>\nNote: Passing ignore_index=True is necessary while passing dictionary or series otherwise a TypeError error will come.<\/div>\n<\/div>\n<\/div>\n<\/div>\n\nMethod 2 – <\/a>Add Series as a row in the dataframe<\/h3>\n
This is another method to append rows in the dataframe. Let us see why this method is needed.<\/p>\n
![\"Add](\"https:\/\/python-programs.com\/wp-content\/uploads\/2021\/04\/Add-Series-as-a-row-in-the-dataframe-in-Pandas.png\")
<\/p>\nd={\"Name\":[\"Mayank\",\"Raj\",\"Rahul\",\"Samar\"],\r\n \"Marks\":[90,88,97,78]\r\n }\r\ndf=pd.DataFrame(d)\r\nprint(df)\r\nprint(\"---------------\")\r\nnew_d={\"Name\":[\"Gaurav\",\"Vijay\"],\r\n \"Marks\":[76,88]}\r\nnew_df=df.append(new_d,ignore_index=True)\r\nprint(new_df)<\/pre>\nOutput:<\/strong><\/p>\n
Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n---------------\r\n Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n4 [Gaurav, Vijay] [76, 88]<\/pre>\n
If we want to add multiple rows at one time and we try it using a dictionary then we get output like this then we get the output as shown above.<\/p>\n<\/div>\n
To solve this issue we use series. Let us understand what series means.<\/p>\n
Series<\/h3>\n
Series is a 1-D array that stores a single column or row of data in a dataframe.<\/p>\n
syntax: pandas.Series( data, index, dtype, copy)<\/p>\n
series=pd.Series(['Ajay','Vijay'])\r\nprint(series)\r\nprint(type(series))<\/pre>\n
Output<\/p>\n
0 Ajay\r\n1 Vijay\r\ndtype: object\r\n<class 'pandas.core.series.Series'><\/pre>\n
That is how we can create a series in pandas. Now we see how we can append series in pandas dataframe. It is similar like as we pass our dictionary. We can simply pass series as an argument in the append() function. Let see this with an example.<\/span><\/p>\n
d={\"Name\":[\"Mayank\",\"Raj\",\"Rahul\",\"Samar\"],\r\n \"Marks\":[90,88,97,78]\r\n }\r\ndf=pd.DataFrame(d)\r\nprint(df)\r\nprint(\"---------------\")\r\nseries=[pd.Series(['Gaurav',88], index=df.columns ) ,\r\n pd.Series(['Vijay', 99], index=df.columns )]\r\nnew_df=df.append(series,ignore_index=True)\r\nprint(new_df)<\/pre>\nOutput:<\/strong><\/p>\n
Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n---------------\r\n Name Marks\r\n0 Mayank 90\r\n1 Raj 88\r\n2 Rahul 97\r\n3 Samar 78\r\n4 Gaurav 88\r\n5 Vijay 99<\/pre>\n
We see that by this method we solve the problem to add multiple rows at a time that we face in the dictionary.<\/p>\n
Method 3 – <\/a>How to Add row from one dataframe to another dataframe<\/h3>\n
To understand this method first we have to understand about concepts of loc.<\/p>\n
loc[ ]<\/h3>\n
It is used to access groups of rows and columns by values. Let us understand this concept with help of an example.<\/p>\n
students = [ ('Mayank',98) ,\r\n ('Raj', 75) ,\r\n ('Rahul', 87) ,\r\n ('Samar', 78)]\r\ndf = pd.DataFrame( students, \r\n columns = ['Name' , 'Marks'],\r\n index=['a', 'b', 'c' , 'd']) \r\nprint(df)\r\nprint(\"------------------\")\r\n# If we want only row 'c' and all columns\r\nprint(df.loc[['c'],:])\r\nprint(\"------------------\")\r\n# If we want only row 'c' and only column 'Name'\r\nprint(df.loc['c']['Name'])\r\nprint(\"------------------\")\r\n# If we want only row 'c' and 'd' and all columns\r\nprint(df.loc[['c','d'],:])\r\nprint(\"------------------\")\r\n# If we want only row 'c' and 'd' and only column 'Name'\r\nprint(df.loc[['c','d'],['Name']])\r\nprint(\"------------------\")<\/pre>\nOutput:<\/strong><\/p>\n
Name Marks\r\na Mayank 98\r\nb Raj 75\r\nc Rahul 87\r\nd Samar 78\r\n------------------\r\n Name Marks\r\nc Rahul 87\r\n------------------\r\nRahul\r\n------------------\r\n Name Marks\r\nc Rahul 87\r\nd Samar 78\r\n------------------\r\n Name\r\nc Rahul\r\nd Samar\r\n------------------<\/pre>\n
This example is very helpful to understand how loc works in pandas.<\/p>\n
Now it can be very easy to understand how we can add rows of one dataframe to another dataframe. Let us see this with an example.<\/p>\n
students1 = [ ('Mayank',98) ,\r\n ('Raj', 75) ,\r\n ('Rahul', 87) ,\r\n ('Samar', 78)]\r\ndf1 = pd.DataFrame( students, \r\n columns = ['Name' , 'Marks'],\r\n index=['a', 'b', 'c' , 'd']) \r\nprint(df1)\r\nprint(\"------------------\")\r\nstudents2 = [ ('Vijay',94) ,\r\n ('Sunil', 76),\r\n ('Sanjay', 80)\r\n ]\r\ndf2= pd.DataFrame( students2, \r\n columns = ['Name' , 'Marks'],\r\n index=['a', 'b','c']) \r\nprint(df2)\r\n\r\nprint(\"------------------\")\r\nnew_df=df1.append(df2.loc[['a','c'],:],ignore_index=True)\r\nprint(new_df)<\/pre>\nOutput:<\/strong><\/p>\n
Name Marks\r\na Mayank 98\r\nb Raj 75\r\nc Rahul 87\r\nd Samar 78\r\n------------------\r\n Name Marks\r\na Vijay 94\r\nb Sunil 76\r\nc Sanjay 80\r\n------------------\r\n Name Marks\r\n0 Mayank 98\r\n1 Raj 75\r\n2 Rahul 87\r\n3 Samar 78\r\n4 Vijay 94\r\n5 Sanjay 80<\/pre>\n
In this example, we see how we easily append rows ‘a’ and ‘c’ of df2 in df1.<\/p>\n
Method 4 – <\/a>How to Add a row in the dataframe at index position using iloc[]<\/h3>\n
iloc[]<\/h3>\n
iloc[] in pandas allows us to retrieve a particular value belonging to a row and column using the index values assigned to it. IT will raise Index errors if a requested indexer is out-of-bounds.<\/p>\n
students1 = [ ('Mayank',98) ,\r\n ('Raj', 75) ,\r\n ('Rahul', 87) ,\r\n ('Samar', 78)]\r\ndf1 = pd.DataFrame( students, \r\n columns = ['Name' , 'Marks'],\r\n index=['a', 'b', 'c' , 'd']) \r\nprint(df1.iloc[0])<\/pre>\nOutput<\/p>\n
Name Mayank\r\nMarks 98\r\nName: a, dtype: object<\/pre>\n
This example shows how we can access any row using an index.<\/p>\n
Note: We use the index in iloc and not the column name.<\/p>\n
Now let us see how we can append row in dataframe using iloc<\/p>\n
students1 = [ ('Mayank',98) ,\r\n('Raj', 75) ,\r\n('Rahul', 87) ,\r\n('Samar', 78)]\r\ndf1 = pd.DataFrame( students, \r\ncolumns = ['Name' , 'Marks'],\r\nindex=['a', 'b', 'c' , 'd']) \r\nprint(\"Original dataframe\")\r\nprint(df1)\r\nprint(\"------------------\")\r\ndf1.iloc[2] = ['Vijay', 80]\r\nprint(\"New dataframe\")\r\nprint(df1)<\/pre>\nOutput:<\/strong><\/p>\n
Original dataframe\r\n Name Marks\r\na Mayank 98\r\nb Raj 75\r\nc Rahul 87\r\nd Samar 78\r\n------------------\r\nNew dataframe\r\n Name Marks\r\na Mayank 98\r\nb Raj 75\r\nc Vijay 80\r\nd Samar 78<\/pre>\n
This example shows how we add a column in the dataframe at a specific index using iloc.<\/p>\n
So these are the methods to add or append rows in the dataframe.<\/p>\n
Want to expert in the python programming language? Exploring\u00a0Python Data Analysis using Pandas<\/a>\u00a0tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n
Read more Articles on Python Data Analysis Using Padas \u2013 Add Contents to a Dataframe<\/strong><\/p>\n
- Add Series as a row in the dataframe<\/a><\/li>\n
- How to Add dictionary as a row to dataframe<\/a><\/li>\n