Column not in index Python dataframe

I have a dataframe called opp_sacc.

opp_sacc.columns.tolist()

I get :

['intgid$_x',

 'ps$_x',

 'id$_x',

 'batch_start$_x',

 'batch_end$_x',

 'value_start$',

 'value_end$',

 'name',

 'amount_currency',

 'currency_code_x',

 'currency_code_l$_x',

 'amount_eur',

 'creation_date_x',

 'last_update_date',

 'record_type_l$',

 'opp_type',

 'opp_business_type',

 'opp_category',

 'opp_scope_attribut',

 'opp_priority_level',

 'opp_source',

 'stage',

 'gate',

 'probability_pct',

 'status',

  ]

I try to extract a susbset dataframe composed only from these columns : 'intgid$_x', 'ps$_x',
I try with :

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

But I got this error :

KeyError: "['intgid$_x' 'id$_x'] not in index"

Could you help me please to resolve this problem?
Thanks

asked Nov 22 '18 at 18:05

Nasri

416

It work find on my side

– Wen-Ben
Nov 22 '18 at 18:12

add a comment |

I have a dataframe called opp_sacc.

opp_sacc.columns.tolist()

I get :

['intgid$_x',

 'ps$_x',

 'id$_x',

 'batch_start$_x',

 'batch_end$_x',

 'value_start$',

 'value_end$',

 'name',

 'amount_currency',

 'currency_code_x',

 'currency_code_l$_x',

 'amount_eur',

 'creation_date_x',

 'last_update_date',

 'record_type_l$',

 'opp_type',

 'opp_business_type',

 'opp_category',

 'opp_scope_attribut',

 'opp_priority_level',

 'opp_source',

 'stage',

 'gate',

 'probability_pct',

 'status',

  ]

I try to extract a susbset dataframe composed only from these columns : 'intgid$_x', 'ps$_x',
I try with :

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

But I got this error :

KeyError: "['intgid$_x' 'id$_x'] not in index"

Could you help me please to resolve this problem?
Thanks

asked Nov 22 '18 at 18:05

Nasri

416

It work find on my side

– Wen-Ben
Nov 22 '18 at 18:12

add a comment |

I have a dataframe called opp_sacc.

opp_sacc.columns.tolist()

I get :

['intgid$_x',

 'ps$_x',

 'id$_x',

 'batch_start$_x',

 'batch_end$_x',

 'value_start$',

 'value_end$',

 'name',

 'amount_currency',

 'currency_code_x',

 'currency_code_l$_x',

 'amount_eur',

 'creation_date_x',

 'last_update_date',

 'record_type_l$',

 'opp_type',

 'opp_business_type',

 'opp_category',

 'opp_scope_attribut',

 'opp_priority_level',

 'opp_source',

 'stage',

 'gate',

 'probability_pct',

 'status',

  ]

I try to extract a susbset dataframe composed only from these columns : 'intgid$_x', 'ps$_x',
I try with :

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

But I got this error :

KeyError: "['intgid$_x' 'id$_x'] not in index"

Could you help me please to resolve this problem?
Thanks

asked Nov 22 '18 at 18:05

Nasri

416

I have a dataframe called opp_sacc.

opp_sacc.columns.tolist()

I get :

['intgid$_x',

 'ps$_x',

 'id$_x',

 'batch_start$_x',

 'batch_end$_x',

 'value_start$',

 'value_end$',

 'name',

 'amount_currency',

 'currency_code_x',

 'currency_code_l$_x',

 'amount_eur',

 'creation_date_x',

 'last_update_date',

 'record_type_l$',

 'opp_type',

 'opp_business_type',

 'opp_category',

 'opp_scope_attribut',

 'opp_priority_level',

 'opp_source',

 'stage',

 'gate',

 'probability_pct',

 'status',

  ]

I try to extract a susbset dataframe composed only from these columns : 'intgid$_x', 'ps$_x',
I try with :

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

But I got this error :

KeyError: "['intgid$_x' 'id$_x'] not in index"

Could you help me please to resolve this problem?
Thanks

python pandas dataframe

asked Nov 22 '18 at 18:05

Nasri

416

asked Nov 22 '18 at 18:05

Nasri

416

asked Nov 22 '18 at 18:05

Nasri

416

asked Nov 22 '18 at 18:05

Nasri

416

asked Nov 22 '18 at 18:05

Nasri

416

It work find on my side

– Wen-Ben
Nov 22 '18 at 18:12

add a comment |

It work find on my side

– Wen-Ben
Nov 22 '18 at 18:12

It work find on my side

– Wen-Ben
Nov 22 '18 at 18:12

add a comment |

1 Answer
1

active

oldest

votes

If your exact error message is

KeyError: "['intgid$_x' 'id$_x'] not in index"

it seems you are missing the comma. Did you tried exactly

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

as you wrote?

answered Nov 22 '18 at 18:26

anotherone

409417

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53436248%2fcolumn-not-in-index-python-dataframe%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

If your exact error message is

KeyError: "['intgid$_x' 'id$_x'] not in index"

it seems you are missing the comma. Did you tried exactly

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

as you wrote?

answered Nov 22 '18 at 18:26

anotherone

409417

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

add a comment |

If your exact error message is

KeyError: "['intgid$_x' 'id$_x'] not in index"

it seems you are missing the comma. Did you tried exactly

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

as you wrote?

answered Nov 22 '18 at 18:26

anotherone

409417

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

add a comment |

If your exact error message is

KeyError: "['intgid$_x' 'id$_x'] not in index"

it seems you are missing the comma. Did you tried exactly

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

as you wrote?

answered Nov 22 '18 at 18:26

anotherone

409417

If your exact error message is

KeyError: "['intgid$_x' 'id$_x'] not in index"

it seems you are missing the comma. Did you tried exactly

opp_sacc=opp_sacc[['intgid$_x','id$_x']]

as you wrote?

answered Nov 22 '18 at 18:26

anotherone

409417

answered Nov 22 '18 at 18:26

anotherone

409417

answered Nov 22 '18 at 18:26

anotherone

409417

answered Nov 22 '18 at 18:26

anotherone

409417

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

add a comment |

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

Yes I wrote opp_sacc=opp_sacc[['intgid$_x','id$_x']]

– Nasri
Nov 26 '18 at 8:48

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Ytukyg