Questions tagged as 'pandas'

Tagged questions
1
answer

Fill rows with missing dates in DataFrame

I am working with some data from a meteorological station in which the data is distributed by columns in day with 24 hours, predominant direction, wind direction in degrees The problem is that there are days, even full months, that do not com...
asked by 16.04.2018 / 21:25
1
answer

GroupBy Data Validation

It is necessary to group the items by name Then we must see that all those with the same names also coincide in RREF1, RREF2, RREF3 and if they are not the same in the RREF that says which. # Agrupacion por valores similares en column...
asked by 09.04.2018 / 22:39
1
answer

Integer numbers in pandas python "dataframe"

I import a document to jupiter and enter normal with whole numbers, I apply a formula to group, add and then subtract and the product leaves all the numbers with decimals and exponentials. How do I get only whole numbers ??? ::::::: attach...
asked by 12.04.2018 / 00:25
1
answer

Pandas convert non-null objects

After importing using urlib , Internet data, I can create a DataFrame (df) with two columns (Fecha y Valor) of the types: Fecha 1563 non-null object, Valor 1563 non-null object. With the statement df["Fecha"] =...
asked by 15.01.2018 / 13:02
1
answer

How to call data in csv of date and time that are in the same column, to make a daytime cycle?

I am very new to this! I'm looking at a class called data analysis, where we are asked to perform a diurnal cycle of a time series that measures radiation per minute, but I have a file in csv where in a single column I have the date and time, as...
asked by 25.11.2016 / 18:27
1
answer

DataFrame cleanup

I have a dataframe where there is an index and several columns, in the columns there are empty rows (my idea is not to eliminate them, but to fill them, since I do not want to lose so much data) I know a lot of the information of that column (wi...
asked by 29.08.2018 / 15:52
2
answers

Replace commas with points in a dataframe (comma as decimal separator)

I'm new to pandas and I have a question about changing points by commas in Python 2. The numbers in the csv are presented this way: As you can see in the image, the floats have different number of decimals. First I tried to change...
asked by 22.07.2018 / 06:07
1
answer

Python Pandas error "ValueError: can not merge DataFrame with instance of type class 'list'"

I need to add data from other dataframes in a dataframe, using the merge function, to get it to only take those values whose indexes have the same date. The sentence that I show next, returns me the error mentioned in the Title. df_total = pd....
asked by 08.08.2018 / 20:57
1
answer

DataFrame.set_index has no effect

set_index does not work on Pandas DataFrame as indicated in the documentation. I'm using: Pandas version 0.20.3 Python version 3.6 I tried the example in the documentation: link import numpy as np import pandas as pd...
asked by 14.11.2017 / 23:25
0
answers

Problem when pivoting a dataframe from two concatenated dataframes

Use Python 3.5 and Pandas 0.20.3 I get an error when I try to pivot a panda dataframe which I obtained using the concat function. I detail the process. This is my first dataframe. df = pd.DataFrame([ ['2017-01-03 21:00:00','2017-01-03...
asked by 05.11.2017 / 10:51