T-test and importing data from columns

I am trying to conduct a T-test on two unequal samples using the following code.

import pandas as pd

import numpy as np

from scipy import stats



UG = pd.read_csv('Mostfrequentscores.csv')

print('Mean', UG['Iceland'].mean())

print('Mean', UG['Peru'].mean())



I = UG['Iceland']

P = UG['Peru']



t = stats.ttest_ind(I, P, equal_var = False)

The mean prints fine, which I assume means its reading the columns in the file - but the T-test keeps on giving me the following error:

C:UsersmsuAnaconda3libsite-packagesscipystats_distn_infrastructure.py:879:
RuntimeWarning: invalid value encountered in greater

Could this be due to my data which is a series of numbers from -3 to 3? Do I need to convert it using float?

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

Have you checked if I or P contain nan values ?

– Gusto
Nov 22 '18 at 7:49

Thans for the reply Yes I did. Just negative, positive and 0 values.

– MS.TO
Nov 22 '18 at 8:12

can you tell us what happens if you do convert to float? (would there be some zero integer mean used to divide and get variance or something?)

– Silmathoron
Nov 22 '18 at 11:01

I get the same error. i tried the following for the one column: Per = UG['peru'].astype(float)

– MS.TO
Nov 22 '18 at 20:08

You will have to post some of your data, otherwise it is hard to help.

– Cleb
Nov 23 '18 at 13:39

add a comment |

I am trying to conduct a T-test on two unequal samples using the following code.

import pandas as pd

import numpy as np

from scipy import stats



UG = pd.read_csv('Mostfrequentscores.csv')

print('Mean', UG['Iceland'].mean())

print('Mean', UG['Peru'].mean())



I = UG['Iceland']

P = UG['Peru']



t = stats.ttest_ind(I, P, equal_var = False)

The mean prints fine, which I assume means its reading the columns in the file - but the T-test keeps on giving me the following error:

C:UsersmsuAnaconda3libsite-packagesscipystats_distn_infrastructure.py:879:
RuntimeWarning: invalid value encountered in greater

Could this be due to my data which is a series of numbers from -3 to 3? Do I need to convert it using float?

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

Have you checked if I or P contain nan values ?

– Gusto
Nov 22 '18 at 7:49

Thans for the reply Yes I did. Just negative, positive and 0 values.

– MS.TO
Nov 22 '18 at 8:12

can you tell us what happens if you do convert to float? (would there be some zero integer mean used to divide and get variance or something?)

– Silmathoron
Nov 22 '18 at 11:01

I get the same error. i tried the following for the one column: Per = UG['peru'].astype(float)

– MS.TO
Nov 22 '18 at 20:08

You will have to post some of your data, otherwise it is hard to help.

– Cleb
Nov 23 '18 at 13:39

add a comment |

I am trying to conduct a T-test on two unequal samples using the following code.

import pandas as pd

import numpy as np

from scipy import stats



UG = pd.read_csv('Mostfrequentscores.csv')

print('Mean', UG['Iceland'].mean())

print('Mean', UG['Peru'].mean())



I = UG['Iceland']

P = UG['Peru']



t = stats.ttest_ind(I, P, equal_var = False)

The mean prints fine, which I assume means its reading the columns in the file - but the T-test keeps on giving me the following error:

C:UsersmsuAnaconda3libsite-packagesscipystats_distn_infrastructure.py:879:
RuntimeWarning: invalid value encountered in greater

Could this be due to my data which is a series of numbers from -3 to 3? Do I need to convert it using float?

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

I am trying to conduct a T-test on two unequal samples using the following code.

import pandas as pd

import numpy as np

from scipy import stats



UG = pd.read_csv('Mostfrequentscores.csv')

print('Mean', UG['Iceland'].mean())

print('Mean', UG['Peru'].mean())



I = UG['Iceland']

P = UG['Peru']



t = stats.ttest_ind(I, P, equal_var = False)

The mean prints fine, which I assume means its reading the columns in the file - but the T-test keeps on giving me the following error:

C:UsersmsuAnaconda3libsite-packagesscipystats_distn_infrastructure.py:879:
RuntimeWarning: invalid value encountered in greater

Could this be due to my data which is a series of numbers from -3 to 3? Do I need to convert it using float?

python pandas scipy probability t-test

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

edited Nov 23 '18 at 13:38

Cleb

11k125482

edited Nov 23 '18 at 13:38

Cleb

11k125482

edited Nov 23 '18 at 13:38

Cleb

11k125482

asked Nov 22 '18 at 7:18

MS.TO

asked Nov 22 '18 at 7:18

MS.TO

asked Nov 22 '18 at 7:18

MS.TO

Have you checked if I or P contain nan values ?

– Gusto
Nov 22 '18 at 7:49

Thans for the reply Yes I did. Just negative, positive and 0 values.

– MS.TO
Nov 22 '18 at 8:12

can you tell us what happens if you do convert to float? (would there be some zero integer mean used to divide and get variance or something?)

– Silmathoron
Nov 22 '18 at 11:01

I get the same error. i tried the following for the one column: Per = UG['peru'].astype(float)

– MS.TO
Nov 22 '18 at 20:08

You will have to post some of your data, otherwise it is hard to help.

– Cleb
Nov 23 '18 at 13:39

add a comment |

Have you checked if I or P contain nan values ?

– Gusto
Nov 22 '18 at 7:49

Thans for the reply Yes I did. Just negative, positive and 0 values.

– MS.TO
Nov 22 '18 at 8:12

can you tell us what happens if you do convert to float? (would there be some zero integer mean used to divide and get variance or something?)

– Silmathoron
Nov 22 '18 at 11:01

I get the same error. i tried the following for the one column: Per = UG['peru'].astype(float)

– MS.TO
Nov 22 '18 at 20:08

You will have to post some of your data, otherwise it is hard to help.

– Cleb
Nov 23 '18 at 13:39

Have you checked if I or P contain nan values ?

– Gusto
Nov 22 '18 at 7:49

Thans for the reply Yes I did. Just negative, positive and 0 values.

– MS.TO
Nov 22 '18 at 8:12

can you tell us what happens if you do convert to float? (would there be some zero integer mean used to divide and get variance or something?)

– Silmathoron
Nov 22 '18 at 11:01

I get the same error. i tried the following for the one column: Per = UG['peru'].astype(float)

– MS.TO
Nov 22 '18 at 20:08

You will have to post some of your data, otherwise it is hard to help.

– Cleb
Nov 23 '18 at 13:39

add a comment |

0

active

oldest

votes

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%2f53425688%2ft-test-and-importing-data-from-columns%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

0

active

oldest

votes

0

active

oldest

votes

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

Search This Blog

Ufyukyu