menu

Linear Algebra

Prob and Stats

Other math topics

Machine Learning

search

Search

Login

Unlock 100+ guides

menu

menu

search toc

close

Outline

Examples Accessing a value Setting a value Related

Comments

Log in or sign up

Cancel

Post

account_circle

exit_to_app

Sign out

search

keyboard_voice

close

Searching Tips

Search for a recipe:
"Creating a table in MySQL"

Search for an API documentation: "@append"

Search for code: "!dataframe"

Apply a tag filter: "#python"

Useful Shortcuts

/ to open search panel

Esc to close search panel

↑↓ to navigate between search results

⌘d to clear all current filters

⌘Enter to expand content preview

icon_star

Doc Search

icon_star

Code Search Beta

SORRY NOTHING FOUND!

mic

Start speaking...

Voice search is only supported in Safari and Chrome.

fullscreen_exit

Shrink

Navigate to

Pandas

655 guides

keyboard_arrow_down

Linear Algebra

Prob and Stats

Machine Learning

Other math topics

chevron_leftData Indexing and Masks

Method all Method any Method isin Method isna Method isnull Method mask Method notna Method where Property at Property iat Property iloc Property loc

check_circle

Mark as learned

thumb_up

0

thumb_down

0

chat_bubble_outline

0

Comment

auto_stories Bi-column layout

settings

Pandas DataFrame | at property

schedule May 20, 2023

Last updated

local_offer

Python●Pandas

Tags

tocTable of Contents

expand_more

Examples Accessing a value Setting a value

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

Panda's DataFrame.at property is used to access or update a single value in the DataFrame using row/column labels.

The syntax is as follows:


        
        
            
                
                
                    DataFrame.at["row_name", "column_name"]

Examples

Consider the following DataFrame:


        
        
            
                
                
                    df = pd.DataFrame({"A":[1,2], "B":[3,4]}, index=["a","b"])
df
                
            
               A  B
a  1  3
b  2  4

Accessing a value

To access the value at row a column B:


        
        
            
                
                
                    df.at["a","B"]
                
            
            3

Setting a value

To set a new value for row a column B:


        
        
            
                
                
                    df.at["a","B"] = 5
df
                
            
               A  B
a  1  5
b  2  4

Related

Pandas DataFrame | iat property

Access or update a single value in the DataFrame using integer syntax.

chevron_right

Pandas DataFrame | iloc property

Access and update specific rows/columns of the DataFrame using integer indices.

chevron_right

Pandas DataFrame | loc property

Access and update values of the DataFrame using row and column labels.

chevron_right

robocat

Published by Isshin Inada

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

Official Pandas Documentation

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.at.html

thumb_up

0

thumb_down

0

chat_bubble_outline

0

settings

Enjoy our search

Hit / to insta-search docs and recipes!

Navigation

Contact us

Resources

Python Pandas MySQL Beautiful Soup Matplotlib NumPy PySpark

Community

Join our Discord

Join our newsletter for updates on new comprehensive DS/ML guides

|