i trying clarify how can manage pandas methods call columns , rows in dataframe. example clarify issue
dic = {'a': [1, 5, 2, 7], 'b': [6, 8, 4, 2], 'c': [5, 3, 2, 7]} df = pd.dataframe(dic, index = ['e', 'f', 'g', 'h'] ) than
df = b c e 1 6 5 f 5 8 3 g 2 4 2 h 7 2 7 now if want select column 'a' have type
df['a'] while if want select row 'e' have use ".loc" method
df.loc['e'] if don't know name of row, it's position ( 0 in case) can use "iloc" method
df.iloc[0] what looks missing method calling columns position , not name, "equivalent columns of 'iloc' method rows". way can find is
df[df.keys()[0]] is there like
df.iloccolumn[0] ?
you can add : because first argument position of selected indexes , second position of columns in function iloc:
and : means indexes in dataframe:
print (df.iloc[:,0]) e 1 f 5 g 2 h 7 name: a, dtype: int64 if need select first index , first column value:
print (df.iloc[0,0]) 1 solution ix work nice if need select index name , column position:
print (df.ix['e',0]) 1
Comments
Post a Comment