Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprende Accessing Specific Columns | Accessing DataFrame Values
Introduction to pandas [track]

bookAccessing Specific Columns

How to get a certain column in a DataFrame? Put column name (as string, in quotes) between square brackets and place it right to variable with dataframe. Another way is to refer to column like to attribute - put column name (without quotes) right to dot symbol placed right to variable with dataframe (it works only for column that has only one word in name).

123456789
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Get 'year' column print(df['year']) # Get 'model' column print(df.model)
copy

If you want to get several columns at once, you need to pass list of columns you want to get. The second approach described above doesn't work here.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Get columns 'model' and 'year' print(df[['model', 'year']])
copy

Pay attention to square brackets. Syntax df(['model', 'year']) will not work!

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 3. Capítulo 1

Pregunte a AI

expand

Pregunte a AI

ChatGPT

Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla

Suggested prompts:

Pregunte me preguntas sobre este tema

Resumir este capítulo

Mostrar ejemplos del mundo real

Awesome!

Completion rate improved to 3.33

bookAccessing Specific Columns

Desliza para mostrar el menú

How to get a certain column in a DataFrame? Put column name (as string, in quotes) between square brackets and place it right to variable with dataframe. Another way is to refer to column like to attribute - put column name (without quotes) right to dot symbol placed right to variable with dataframe (it works only for column that has only one word in name).

123456789
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Get 'year' column print(df['year']) # Get 'model' column print(df.model)
copy

If you want to get several columns at once, you need to pass list of columns you want to get. The second approach described above doesn't work here.

1234567
# Importing library import pandas as pd # Reading csv file df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv') # Get columns 'model' and 'year' print(df[['model', 'year']])
copy

Pay attention to square brackets. Syntax df(['model', 'year']) will not work!

¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 3. Capítulo 1
some-alt