import pandas as pd
import numpy as np
dict_data = {
'CL': [100,800,200],
'CO': [100,200,300],
'MX': [300,500,400]
}
dict_data
df = pd.DataFrame(dict_data)
df
dict_data = {
'edad' : [ 10, 9, 13, 14, 12, 11, 12],
'cm' : [ 115, 110, 130, 155, 125, 120, 125],
'pais' : [ 'co', 'mx', 'co', 'mx', 'mx', 'ch', 'ch'],
'genero' : [ 'M', 'F', 'F', 'M', 'M', 'M', 'F'],
'Q1' : [ 5, 10, 8, np.nan, 7, 8, 3],
'Q2' : [ 7, 9, 9, 8, 8, 8, 9.]
}
dict_data
df = pd.DataFrame(dict_data, index = ['ana','benito','camilo','daniel','erika','fabian','gabriela'])
df
df.index
df.columns
df.values
df[['edad','cm','Q1']]
df.loc[['ana','erika'],['edad','cm','Q1']]
df.loc['daniel','Q1']
df.iloc[:,[1,3]]
df[(df['edad'] >= 12) & (df['pais'] == 'mx')]
df.query('edad > 12')
df[df['Q2']>=df['Q1']]