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之Seaborn(数据可视化)详细讲解Python之Seaborn(数据可视化)Apr 21, 2022 pm 06:08 PM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于Seaborn的相关问题,包括了数据可视化处理的散点图、折线图、条形图等等内容,下面一起来看一下,希望对大家有帮助。

详细了解Python进程池与进程锁详细了解Python进程池与进程锁May 10, 2022 pm 06:11 PM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于进程池与进程锁的相关问题,包括进程池的创建模块,进程池函数等等内容,下面一起来看一下,希望对大家有帮助。

Python自动化实践之筛选简历Python自动化实践之筛选简历Jun 07, 2022 pm 06:59 PM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于简历筛选的相关问题,包括了定义 ReadDoc 类用以读取 word 文件以及定义 search_word 函数用以筛选的相关内容,下面一起来看一下,希望对大家有帮助。

归纳总结Python标准库归纳总结Python标准库May 03, 2022 am 09:00 AM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于标准库总结的相关问题,下面一起来看一下,希望对大家有帮助。

分享10款高效的VSCode插件,总有一款能够惊艳到你!!分享10款高效的VSCode插件,总有一款能够惊艳到你!!Mar 09, 2021 am 10:15 AM

VS Code的确是一款非常热门、有强大用户基础的一款开发工具。本文给大家介绍一下10款高效、好用的插件,能够让原本单薄的VS Code如虎添翼,开发效率顿时提升到一个新的阶段。

python中文是什么意思python中文是什么意思Jun 24, 2019 pm 02:22 PM

pythn的中文意思是巨蟒、蟒蛇。1989年圣诞节期间,Guido van Rossum在家闲的没事干,为了跟朋友庆祝圣诞节,决定发明一种全新的脚本语言。他很喜欢一个肥皂剧叫Monty Python,所以便把这门语言叫做python。

Python数据类型详解之字符串、数字Python数据类型详解之字符串、数字Apr 27, 2022 pm 07:27 PM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于数据类型之字符串、数字的相关问题,下面一起来看一下,希望对大家有帮助。

详细介绍python的numpy模块详细介绍python的numpy模块May 19, 2022 am 11:43 AM

本篇文章给大家带来了关于Python的相关知识,其中主要介绍了关于numpy模块的相关问题,Numpy是Numerical Python extensions的缩写,字面意思是Python数值计算扩展,下面一起来看一下,希望对大家有帮助。

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)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

ZendStudio 13.5.1 Mac

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment