Mixing
![Is $(E cup F ) - (E cap F)=( E setminus F) cup ( F setminus E)$? [closed]](https://lh3.googleusercontent.com/-s5VPjbei54w/AAAAAAAAAAI/AAAAAAAAAWA/6LEwafLl2xw/s72-c/photo.jpg?sz=32)
Binning a series returns a seemingly unrelated TypeError
0
I am trying to slice a dataframe I created into bins:
picture of dataframe in case it's relevant
# create bins and labels
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
For some reason, I receive this error:
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-73-b938397739fa> in <module>()
9
10 #schoolSummary["Spending Range"] =
---> 11 pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in cut(x, bins, right, labels, retbins, precision, include_lowest, duplicates)
232 include_lowest=include_lowest,
233 dtype=dtype,
--> 234 duplicates=duplicates)
235
236 return _postprocess_for_cut(fac, bins, retbins, x_is_series,
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in _bins_to_cuts(x, bins, right, labels, precision, include_lowest, dtype, duplicates)
335
336 side = 'left' if right else 'right'
--> 337 ids = _ensure_int64(bins.searchsorted(x, side=side))
338
339 if include_lowest:
TypeError: '<' not supported between instances of 'int' and 'str'
I'm confused, because I did not use '<' in the code at all. I also used
print(type(schoolSummary["Per Student Budget"]))
and it is a series object, so I don't know what 'int' and 'str' it's referring to. Is it a problem with my bins or labels?
python pandas jupyter
asked Nov 20 '18 at 19:09
ChristinaChristina
163
add a comment |
0
I am trying to slice a dataframe I created into bins:
picture of dataframe in case it's relevant
# create bins and labels
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
For some reason, I receive this error:
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-73-b938397739fa> in <module>()
9
10 #schoolSummary["Spending Range"] =
---> 11 pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in cut(x, bins, right, labels, retbins, precision, include_lowest, duplicates)
232 include_lowest=include_lowest,
233 dtype=dtype,
--> 234 duplicates=duplicates)
235
236 return _postprocess_for_cut(fac, bins, retbins, x_is_series,
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in _bins_to_cuts(x, bins, right, labels, precision, include_lowest, dtype, duplicates)
335
336 side = 'left' if right else 'right'
--> 337 ids = _ensure_int64(bins.searchsorted(x, side=side))
338
339 if include_lowest:
TypeError: '<' not supported between instances of 'int' and 'str'
I'm confused, because I did not use '<' in the code at all. I also used
print(type(schoolSummary["Per Student Budget"]))
and it is a series object, so I don't know what 'int' and 'str' it's referring to. Is it a problem with my bins or labels?
python pandas jupyter
asked Nov 20 '18 at 19:09
ChristinaChristina
163
3
What does schoolSummary.info() return? If object, then it is a string..... Tryss = pd.to_numeric(schoolSummary)thenpd.cut(ss, bins, labels = labels)
– Scott Boston
Nov 20 '18 at 19:11
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
2
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50
add a comment |
0
0
0
I am trying to slice a dataframe I created into bins:
picture of dataframe in case it's relevant
# create bins and labels
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
For some reason, I receive this error:
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-73-b938397739fa> in <module>()
9
10 #schoolSummary["Spending Range"] =
---> 11 pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in cut(x, bins, right, labels, retbins, precision, include_lowest, duplicates)
232 include_lowest=include_lowest,
233 dtype=dtype,
--> 234 duplicates=duplicates)
235
236 return _postprocess_for_cut(fac, bins, retbins, x_is_series,
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in _bins_to_cuts(x, bins, right, labels, precision, include_lowest, dtype, duplicates)
335
336 side = 'left' if right else 'right'
--> 337 ids = _ensure_int64(bins.searchsorted(x, side=side))
338
339 if include_lowest:
TypeError: '<' not supported between instances of 'int' and 'str'
I'm confused, because I did not use '<' in the code at all. I also used
print(type(schoolSummary["Per Student Budget"]))
and it is a series object, so I don't know what 'int' and 'str' it's referring to. Is it a problem with my bins or labels?
python pandas jupyter
asked Nov 20 '18 at 19:09
ChristinaChristina
163
I am trying to slice a dataframe I created into bins:
picture of dataframe in case it's relevant
# create bins and labels
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
For some reason, I receive this error:
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
<ipython-input-73-b938397739fa> in <module>()
9
10 #schoolSummary["Spending Range"] =
---> 11 pd.cut(schoolSummary["Per Student Budget"], bins, labels = labels)
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in cut(x, bins, right, labels, retbins, precision, include_lowest, duplicates)
232 include_lowest=include_lowest,
233 dtype=dtype,
--> 234 duplicates=duplicates)
235
236 return _postprocess_for_cut(fac, bins, retbins, x_is_series,
~Anaconda3envspy36libsite-packagespandascorereshapetile.py in _bins_to_cuts(x, bins, right, labels, precision, include_lowest, dtype, duplicates)
335
336 side = 'left' if right else 'right'
--> 337 ids = _ensure_int64(bins.searchsorted(x, side=side))
338
339 if include_lowest:
TypeError: '<' not supported between instances of 'int' and 'str'
I'm confused, because I did not use '<' in the code at all. I also used
print(type(schoolSummary["Per Student Budget"]))
and it is a series object, so I don't know what 'int' and 'str' it's referring to. Is it a problem with my bins or labels?
python pandas jupyter
python pandas jupyter
asked Nov 20 '18 at 19:09
ChristinaChristina
163
asked Nov 20 '18 at 19:09
ChristinaChristina
163
asked Nov 20 '18 at 19:09
ChristinaChristina
163
asked Nov 20 '18 at 19:09
ChristinaChristina
163
asked Nov 20 '18 at 19:09
ChristinaChristina
163
163
3
What does schoolSummary.info() return? If object, then it is a string..... Tryss = pd.to_numeric(schoolSummary)thenpd.cut(ss, bins, labels = labels)
– Scott Boston
Nov 20 '18 at 19:11
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
2
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50
add a comment |
3
What does schoolSummary.info() return? If object, then it is a string..... Tryss = pd.to_numeric(schoolSummary)thenpd.cut(ss, bins, labels = labels)
– Scott Boston
Nov 20 '18 at 19:11
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
2
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50
3
3
What does schoolSummary.info() return? If object, then it is a string..... Try
ss = pd.to_numeric(schoolSummary) then pd.cut(ss, bins, labels = labels)– Scott Boston
Nov 20 '18 at 19:11
What does schoolSummary.info() return? If object, then it is a string..... Try
ss = pd.to_numeric(schoolSummary) then pd.cut(ss, bins, labels = labels)– Scott Boston
Nov 20 '18 at 19:11
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
2
2
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50
add a comment |
1 Answer
1
active
oldest
votes
0
Due to low rep, I can't comment to your question,
You must try the following
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
for bin_ in bins:
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bin_, labels = labels)
Because bin takes int type, instead of a list.
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399911%2fbinning-a-series-returns-a-seemingly-unrelated-typeerror%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Due to low rep, I can't comment to your question,
You must try the following
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
for bin_ in bins:
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bin_, labels = labels)
Because bin takes int type, instead of a list.
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
add a comment |
0
Due to low rep, I can't comment to your question,
You must try the following
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
for bin_ in bins:
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bin_, labels = labels)
Because bin takes int type, instead of a list.
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
add a comment |
0
0
0
Due to low rep, I can't comment to your question,
You must try the following
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
for bin_ in bins:
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bin_, labels = labels)
Because bin takes int type, instead of a list.
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
Due to low rep, I can't comment to your question,
You must try the following
bins = [575, 600, 625, 650]
labels = [
"$575-$599",
"$600-$624",
"$625-$649",
"$650-$675"
]
for bin_ in bins:
schoolSummary["Spending Range"] = pd.cut(schoolSummary["Per Student Budget"], bin_, labels = labels)
Because bin takes int type, instead of a list.
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
answered Nov 20 '18 at 19:26
Preetkaran SinghPreetkaran Singh
99111
99111
add a comment |
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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53399911%2fbinning-a-series-returns-a-seemingly-unrelated-typeerror%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
What does schoolSummary.info() return? If object, then it is a string..... Try
ss = pd.to_numeric(schoolSummary)thenpd.cut(ss, bins, labels = labels)– Scott Boston
Nov 20 '18 at 19:11
Do you know that the upper bin-label does correspond with the bin? Your upper boundary is 650,where the label says 675
– Zanshin
Nov 20 '18 at 20:28
@Zanshin Yes, I had two other easy clarification questions I was saving to ask my instructor; thank you
– Christina
Nov 20 '18 at 20:48
2
@ScottBoston I think I understand now, that I need to check the type of the actual values I am using to bin? Is that correct? And the ‘<‘ is behind the scenes when .cut is checking to see if that value is more or less than the values I put in bin =? I will try this when I get home from work tonight
– Christina
Nov 20 '18 at 20:50