Skip to content

Datetime object in DataFrame with just time

This is the plain column And the I would like to put that column in the index, the problem is when I try to use the method resample() I always get the same problem: TypeError: Only valid with DatetimeIndex, TimedeltaIndex or PeriodIndex, but got an instance of ‘Index’ I’ve been using this to…

INSERT INTO SELECT based on a dataframe

I have a dataframe df and I want to to execute a query to insert into a table all the values from the dataframe. Basically I am trying to load as the following query: For that I have the following code: However, I am getting the following error: Does anyone know what I am doing wrong? Answer See below my