problem web logs analysis

Ornicar · April 8

Hello.

I have a problem in the formation : the course ask us to do that

Cleaning
- Remove four columns: br_width, br_height, sc_width and sc_height
- Rename the column client_addr to ip_address
- Clear invalid cells in the ip_address column for the IP address meaning
- Rename the column location to url

How I make those two last points ? Is there a course which learn us to do that ? I don't know how to make that.

Sarina · April 9

Hi @Ornicar
,

Indeed, the following tutorial has details:
https://knowledge.dataiku.com/latest/data-preparation/prepare-recipe/tutorial-web-logs-enrichment.html#tutorial-enrich-web-logs-in-the-prepare-recipe

For renaming columns, you can do so from a prepare recipe with the "Rename columns" processor.

Thank you,
Sarina

Ornicar · April 9

thx

Answers