Message Boards

8462 Views

2 Replies

1 Total Likes

View groups...

Follow this post

Share this post:

GROUPS:

Data Science Mathematics Wolfram Language Units

Perform calculations with the $ symbol within the elements a dataset?

Posted 5 years ago

Hello Wolfram Mathematica community, I've been playing around with Mathematica and I've isolated a set of data on a website; however, there are money signs within the data set. Is it possible to still perform mathematical processes with the $ symbol within the elements in the set? I tried and it thought the money sign was a variable. Attachments: MLB Baseball Salaries.nb

POSTED BY: William Ferguson

2 Replies

Sort By:

Posted 5 years ago

Or use a currency interpreter: data=Import["https://www.usatoday.com/sports/mlb/salaries/",{"Data"}]; salaryStrings=data[[2,2,2,2,All,5]]; salaries=Interpreter["CurrencyAmount"]@salaryStrings//Cases[#,_Quantity]&; Mean@salaries//N

POSTED BY: Vincent Virgilio

Posted 5 years ago

William, The problem is that the data is imported as strings. Part[data2, 2, 2, 2, 2, 1] // InputForm (* {"--", "Max Scherzer", "WSH", "SP", "$42,142,857", "7 (2015-21)", "$210,000,000", "$30,000,000"} *) To convert to numbers, remove the `$` and `,` and then `ToExpression` data = Part[data2, 2, 2, 2, 2, All, 7] // StringReplace[{"$" -> "", "," -> ""}] // Map[ToExpression]; Compute mean N@Mean[data]

William,

The problem is that the data is imported as strings.

Part[data2, 2, 2, 2, 2, 1] // InputForm
(* {"--", "Max Scherzer", "WSH", "SP", "$42,142,857", "7 (2015-21)", "$210,000,000", "$30,000,000"} *)

To convert to numbers, remove the $ and , and then ToExpression

data = Part[data2, 2, 2, 2, 2, All, 7] //
  StringReplace[{"$" -> "", "," -> ""}] // Map[ToExpression];

Compute mean

N@Mean[data]

POSTED BY: Rohit Namjoshi

Reply to this discussion

Reply Preview

Attachments

Remove Add a file to this post

Follow this discussion

or Discard

Feedback