how to get desired row and with column names in pandas dataframe?

Question

following is a preview of a marketing dataframe. Complete the code to get desired output

   id  views  clicks
a  1   1000   300
b  2   1200   800
c  3   800    200

output

   views  clicks
a  1000   300

what should i change in my code to get this output

import pandas as pd
market=pd.read_csv("marketing.csv")
print(market.iloc[0])

i get first row as my output with column names – Ayushi midha Sep 01 '18 at 08:04 — Ayushi midha, Sep 01 '18 at 08:04
no all the columns are named in that – Ayushi midha Sep 01 '18 at 08:32 — Ayushi midha, Sep 01 '18 at 08:32

Sreeram TP · Accepted Answer · 2018-09-01T08:52:34.317

2

You can use iloc like this for your purpose. But you will get a Series

market.iloc[[0], [1, 2]]

or loc like this to get a dataframe

market.loc[['a'], ['views', 'clicks']]

edited Sep 01 '18 at 08:52

answered Sep 01 '18 at 08:04

Sreeram TP

iloc is not printing a – Ayushi midha Sep 01 '18 at 08:17
loc command is showing an error – Ayushi midha Sep 01 '18 at 08:17
@Ayushimidha You need to pass a list of rows for it to show a DataFrame instead of a Series. See the edit. – ayhan Sep 01 '18 at 08:32
loc is still showing error – Ayushi midha Sep 01 '18 at 08:37
iloc command is giving the desired output – Ayushi midha Sep 01 '18 at 08:37
@Ayushimidha I am getting the desired output with loc. What is your pandas version.? – Sreeram TP Sep 01 '18 at 08:43

1 Answers1