search
HomeBackend DevelopmentPython TutorialHow to update rows and columns using Python Pandas

1. Create a Pandas data set

In order to create a data frame, pandas provides the function name pd.DataFrame, which can help you create a data frame from some data. Let's see how it works.

#创建一个字典

import pandas as pd

fruit_data = {"Fruit": ['Apple','Avacado','Banana','Strawberry','Grape'],"Color": ['Red','Green','Yellow','Pink','Green'],
"Price": [45, 90, 60, 37, 49]
}

fruit_data

Here, we create a Python dictionary that includes some data items. Now, we are asked to turn this dictionary into a Pandas dataset.

#Dataframe 

data = pd.DataFrame(fruit_data)
data

How to update rows and columns using Python Pandas

That’s perfect! Using pandas’ pd.DataFrame function, we can easily convert a dictionary into a pandas dataset. Our dataset is now ready for future operations.

Update Columns

Sometimes the columns or names of features are inconsistent. It can be uppercase and lowercase of the alphabet, etc. Having a unified design helps us use these features effectively.

So as a first step we will understand how to update/change column or feature names in the data.

#update the column name

data.rename(columns = {'Fruit':'Fruit Name'})

How to update rows and columns using Python Pandas

#Simple as shown above. You can even update multiple column names at once. To do this we have to add additional column names separated by commas under curly braces.

#multile column update

data.rename(columns = {'Fruit':'Fruit Name','Colour':'Color','Price':'Cost'})

Like this, we can update all columns at the same time.

Update case of column names

When processing a data set with many columns, we may encounter inconsistent column names.

In our data, you can observe that the first letter of all column names is capitalized. It is always recommended to use common case for all column names.

Well, we can convert them to uppercase or lowercase.

#lower case

data.columns.str.lower()
data

How to update rows and columns using Python Pandas

Now, all of our column names are lowercase.

Updating rows

Like updating columns, updating rows is also very simple. We must find the row value before we can update the row with the new value.

We can use pandas loc function to locate rows.

#updating rows

data.loc[3]
Fruit    Strawberry
Color          Pink
Price            37
Name: 3, dtype: object

We found row 3 which contains the details of the fruit strawberry. We need to update this row to provide a new fruit name as Pineapple and its details.

#update

data.loc[3] = ['PineApple','Yellow','48']
data

How to update rows and columns using Python Pandas

I hope you all also find it easy to update the value of a row in your data. Now, let's say we only need to update some details in the row, rather than the entire detail. So, what do you think about this?

#更新特定值

data.loc[3, ['Price']]
Price    48
Name: 3, dtype: object

We only need to update the price of the fruit located in row 3. We know that the current price of the fruit is 48. However, we have to update it to 65. Let's do this.

#updating 

data.loc[3, ['Price']] = [65]
data

How to update rows and columns using Python Pandas

We update the price of the fruit pineapple to 65 with just one line of python code. This is how it works. simple.

Update rows and columns based on conditions

Yes, we will now update row values ​​based on specific conditions. Finally, we want some meaningful values ​​that should help our analysis.

Let's define our conditions.

#Condition

updated = data['Price'] > 60
updated

What we want to do here is update the price of fruits above 60 to expensive.

0    False
1     True
2    False
3     True
4    False
Name: Price, dtype: bool

According to the output, we have 2 fruits with price above 60. Let's list these fruits as expensive in the data.

#Updating

data.loc[updated, 'Price'] = 'Expensive'
data

How to update rows and columns using Python Pandas

The above is the detailed content of How to update rows and columns using Python Pandas. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:亿速云. If there is any infringement, please contact admin@php.cn delete
Python: Games, GUIs, and MorePython: Games, GUIs, and MoreApr 13, 2025 am 12:14 AM

Python excels in gaming and GUI development. 1) Game development uses Pygame, providing drawing, audio and other functions, which are suitable for creating 2D games. 2) GUI development can choose Tkinter or PyQt. Tkinter is simple and easy to use, PyQt has rich functions and is suitable for professional development.

Python vs. C  : Applications and Use Cases ComparedPython vs. C : Applications and Use Cases ComparedApr 12, 2025 am 12:01 AM

Python is suitable for data science, web development and automation tasks, while C is suitable for system programming, game development and embedded systems. Python is known for its simplicity and powerful ecosystem, while C is known for its high performance and underlying control capabilities.

The 2-Hour Python Plan: A Realistic ApproachThe 2-Hour Python Plan: A Realistic ApproachApr 11, 2025 am 12:04 AM

You can learn basic programming concepts and skills of Python within 2 hours. 1. Learn variables and data types, 2. Master control flow (conditional statements and loops), 3. Understand the definition and use of functions, 4. Quickly get started with Python programming through simple examples and code snippets.

Python: Exploring Its Primary ApplicationsPython: Exploring Its Primary ApplicationsApr 10, 2025 am 09:41 AM

Python is widely used in the fields of web development, data science, machine learning, automation and scripting. 1) In web development, Django and Flask frameworks simplify the development process. 2) In the fields of data science and machine learning, NumPy, Pandas, Scikit-learn and TensorFlow libraries provide strong support. 3) In terms of automation and scripting, Python is suitable for tasks such as automated testing and system management.

How Much Python Can You Learn in 2 Hours?How Much Python Can You Learn in 2 Hours?Apr 09, 2025 pm 04:33 PM

You can learn the basics of Python within two hours. 1. Learn variables and data types, 2. Master control structures such as if statements and loops, 3. Understand the definition and use of functions. These will help you start writing simple Python programs.

How to teach computer novice programming basics in project and problem-driven methods within 10 hours?How to teach computer novice programming basics in project and problem-driven methods within 10 hours?Apr 02, 2025 am 07:18 AM

How to teach computer novice programming basics within 10 hours? If you only have 10 hours to teach computer novice some programming knowledge, what would you choose to teach...

How to avoid being detected by the browser when using Fiddler Everywhere for man-in-the-middle reading?How to avoid being detected by the browser when using Fiddler Everywhere for man-in-the-middle reading?Apr 02, 2025 am 07:15 AM

How to avoid being detected when using FiddlerEverywhere for man-in-the-middle readings When you use FiddlerEverywhere...

What should I do if the '__builtin__' module is not found when loading the Pickle file in Python 3.6?What should I do if the '__builtin__' module is not found when loading the Pickle file in Python 3.6?Apr 02, 2025 am 07:12 AM

Error loading Pickle file in Python 3.6 environment: ModuleNotFoundError:Nomodulenamed...

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools