0

Bascially, i have a code that filters the data coming from the API. The data is reasonable, however, the values of the active Users are in string format. Once I changed them (to integers), my max value and all the value change! Even if I use excel, the same thing happens, and it is not realistic to have 1 million active users as it appears later on. Why this can be happening? I checked a lot of stuff and nothing.

This is the max value before transforming:


activeUsers    994

This is the describe after the transformation:


count    6.110000e+02
mean     3.721185e+03
std      4.682527e+04
min      3.000000e+00
25%      3.550000e+01
50%      1.740000e+02
75%      7.140000e+02
max      1.133340e+06
Name: activeUsers, dtype: float64
Improve this question
2
  • Consider converting data in the column to integers df['activeUsers'] = df['activeUsers'].astype(int) Commented Jun 5, 2024 at 17:12
  • Already did it. I already use pd.numeric as well. That is my problem, once converting to integers, the data appears to change (at least its max value, which was a string number before). But maybe the problem is how the strings are recognized as max values, and the underlying problem is that the data cannot be the same due problems with the API. Who knows! Commented Jun 7, 2024 at 12:48
Related questions
987
How to allow only numeric (0-9) in HTML inputbox using jQuery?
679
Why is the result of ('b'+'a'+ + 'a' + 'a').toLowerCase() 'banana'?
1
Time taken to reflect the custom dimension changes in GA4
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.