Member Avatar for glez_b
glez_b 0 Newbie Poster

I have a monthly database and the daily data are every 15 minutes. Develop a script to calculate the average and sum of some variables. The data have the following structure:

MagViento, DirViento, u, v, Humedad, Precipitacion
5.67, 245 , 7.7898, 6.5660, 100, 4.1

When I run the script, I get the following output:

Fecha DirRes Humedad MagRes PreciAcu Temperatura

2011/07/01 141.058824 100.000000 4.647059 30.4 21.367059
2011/07/02 153.823529 99.823529 3.470588 18.0 21.841765
2011/07/03 133.882353 99.823529 4.647059 4.0 21.347059

Now I want to save the output to a csv file, but I would like the columns were rounded to 1, eg: 153.823529 = 153.8. After that i get this, now i want to convert the columns: DirRes and Humedad to an integer and MagRes, PreciAcu and Temperatura remain as float

How I can achieve this in pandas or if there is another way to get this, appreciate your help

  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.