Python Pandas Syntax problem? Wrong Output, any ideas?

[Gbuoy]

Hello!

I was hoping to get some input on why my code is not working as intended. I want to produce the mean and median value of a Pandas series that contains the input from a previously read in Excel file, but I believe there is an error in my method. Any assistance would be much appreciated.

Here is my code:

df = pd.read_csv('train.csv')
id_values = pd.Series(df['PassengerId'])      

PassengerMedian = pd.Series.median(df['PassengerId'])
PassengerMean = pd.Series.mean(df['PassengerId'])

print(f"ID mean is {PassengerMean}; median value is :{PassengerMedian}")

display(id_values)

The problem is that as well as showing the values of PassengerId it says "ID mean is 446.0; median value is :446.0 ". Any hints on how to fix this? Cheers!

buran write Jan-18-2023, 09:48 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[deanhystad]

Where is the "Syntax problem" mentioned in the title?

I do not understand this statement:

The problem is that as well as showing the values of PassengerId it says "ID mean is 446.0; median value is :446.0 "

Your program contains a print statement that prints "ID mean is 446.0; median value is :446.0 ". If you don't want to print the message, why do you include the print statement in your program?

I could understand if you wanted to get rid of this message that is printed after the list of passenger id's:

Output:
Name: PassengerId, dtype: int64

Or is display(id_values) a special function that pretty prints the series?

[snippsat]

mean and median can give same output it depends on input data.
Read a little about the diffrence.
You can also call it directly on id_values.mean().
Example.

import pandas as pd

data = {'PassengerId': (2, 3, 3, 4, 6, 8, 9)}
df = pd.DataFrame(data)

>>> id_values = pd.Series(df['PassengerId'])
>>> id_values.mean()
5.0
>>> id_values.median()
4.0

If input data is like this then vaules is the same.

import pandas as pd

data = {'PassengerId': (1, 2, 3, 4, 5, 6, 7)}
df = pd.DataFrame(data)

>>> id_values = pd.Series(df['PassengerId'])
>>> id_values.mean()
4.0
>>> id_values.median()
4.0