Conditional column data replacement

Questions
1

How do I conditionally replace every float in the “muncipality_name” column with corresponding row data from the “toll_company” column?

image11.jpeg
image11.jpeg312×224 24.1 KB

2

Is this a Mathematica question? It looks like a spreadsheet question. Are you importing the spreadsheet to a Dataset, and does your question apply to the Dataset?

3

It is a Mathematica question, I am only using a spreadsheet to show what the data looks like, it was a CSV file separated by “;” so I imported it and applied a field separator, the challenge now is is some of the data from the last 3 columns overlapped, I’m trying to correct that by replacing the floats with the corresponding name from the preceding column.

4

Okay, then it’d be easier if you gave us the representation you have in Mathematica.

5

data = {{“toll_cordon”, “toll_cordon_section”, “toll_company”,
“municipality_name”}, {“Oslo”, “Osloringen”, “Oslo”,
59.92}, {“Oslo”, “Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”,
“Osloringen”, “Oslo”, 59.9221}, {“Oslo”, “Osloringen”, “Fjellinjen”,
“Oslo”}, {“Oslo”, “Osloringen”, “Oslo”, 59.9315}, {“Oslo”,
“Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”, “Osloringen”,
“Fjellinjen”, “Oslo”}, {“Oslo”, “Osloringen”, “Oslo”,
59.9467}, {“Oslo”, “Osloringen”, “Oslo”, 59.9401}, {“Oslo”,
“Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”, “Osloringen”, “Oslo”,
59.9236}, {“Oslo”, “Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”,
“Osloringen”, “Oslo”, 59.8791}, {“Oslo”, “Osloringen”, “Oslo”,
59.8782}, {“Oslo”, “Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”,
“Osloringen”, “Fjellinjen”, “Oslo”}, {“Oslo”, “Osloringen”,
“Fjellinjen”, “Oslo”}, {“Oslo”, “Osloringen”, “Oslo”,
59.8849}, {“Oslo”, “Osloringen”, “Oslo”, 59.9509}}

6

Maybe something like this:

data /. {head___, m_String, _?NumberQ} :> {head, m, m}
7

This did the job, thanks a lot!