problem web logs analysis

[Ornicar]

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.

[SarinaS]

Hi @Ornicar,

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

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

Thank you,
Sarina

[Ornicar]

thx