def test_serialization_for_nan_in_columns_starting_with_digits(self): from influxdb_client.extras import pd from influxdb_client.extras import np data_frame = pd.DataFrame(data={ '1value': [np.nan, 30.0, np.nan, 30.0, np.nan], '2value': [30.0, np.nan, np.nan, np.nan, np.nan], '3value': [30.0, 30.0, 30.0, np.nan, np.nan], 'avalue': [30.0, 30.0, 30.0, 30.0, 30.0] }, index=pd.period_range('2020-05-24 10:00', freq='H', periods=5)) points = data_frame_to_list_of_points( data_frame, PointSettings(), data_frame_measurement_name='test') self.assertEqual(5, len(points)) self.assertEqual( 'test 2value=30.0,3value=30.0,avalue=30.0 1590314400000000000', points[0]) self.assertEqual( 'test 1value=30.0,3value=30.0,avalue=30.0 1590318000000000000', points[1]) self.assertEqual('test 3value=30.0,avalue=30.0 1590321600000000000', points[2]) self.assertEqual('test 1value=30.0,avalue=30.0 1590325200000000000', points[3]) self.assertEqual('test avalue=30.0 1590328800000000000', points[4]) data_frame = pd.DataFrame(data={ '1value': [np.nan], 'avalue': [30.0], 'bvalue': [30.0] }, index=pd.period_range('2020-05-24 10:00', freq='H', periods=1)) points = data_frame_to_list_of_points( data_frame, PointSettings(), data_frame_measurement_name='test') self.assertEqual(1, len(points)) self.assertEqual('test avalue=30.0,bvalue=30.0 1590314400000000000', points[0])
def test_with_period_index(self): from influxdb_client.extras import pd, np now = pd.Timestamp('2020-04-05 00:00+00:00') data_frame = pd.DataFrame(data={ 'value': [1, 2], }, index=pd.period_range(start='2020-04-05 01:00+00:00', freq='H', periods=2)) points = data_frame_to_list_of_points(data_frame=data_frame, point_settings=PointSettings(), data_frame_measurement_name='h2o') self.assertEqual(2, len(points)) self.assertEqual("h2o value=1i 1586048400000000000", points[0]) self.assertEqual("h2o value=2i 1586052000000000000", points[1])
def test_specify_timezone_period_time_index(self): from influxdb_client.extras import pd data_frame = pd.DataFrame(data={ 'value1': [10, 20], 'value2': [30, 40], }, index=pd.period_range( start='2020-05-24 10:00', freq='H', periods=2)) print(data_frame.to_string()) points = data_frame_to_list_of_points( data_frame=data_frame, data_frame_measurement_name="test", data_frame_timestamp_timezone="Europe/Berlin", point_settings=PointSettings()) self.assertEqual(2, len(points)) self.assertEqual('test value1=10i,value2=30i 1590307200000000000', points[0]) self.assertEqual('test value1=20i,value2=40i 1590310800000000000', points[1])