Python convert_sql_column示例

示例#1

文件： test_infer_and_convert.py 项目： Feyi1/pandas

    def test_convert_sql_column_bools(self):
        arr = np.array([True, False, True, False], dtype="O")
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, True, False], dtype=bool)
        self.assert_numpy_array_equal(result, expected)

        arr = np.array([True, False, None, False], dtype="O")
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, np.nan, False], dtype=object)
        self.assert_numpy_array_equal(result, expected)

示例#2

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

    def test_convert_sql_column_bools(self):
        arr = np.array([True, False, True, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, True, False], dtype=bool)
        self.assert_numpy_array_equal(result, expected)

        arr = np.array([True, False, None, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, np.nan, False], dtype=object)
        self.assert_numpy_array_equal(result, expected)

示例#3

文件： test_infer_and_convert.py 项目： Feyi1/pandas

    def test_convert_sql_column_longs(self):
        arr = np.array([long(1), long(2), long(3), long(4)], dtype="O")
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype="i8")
        self.assert_numpy_array_equal(result, expected)

        arr = np.array([long(1), long(2), long(3), None, long(4)], dtype="O")
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype="f8")
        self.assert_numpy_array_equal(result, expected)

示例#4

文件： test_lib.py 项目： danielmoralesp/python-basics

    def test_convert_sql_column_longs(self):
        arr = np.array([long(1), long(2), long(3), long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        _assert_same_values_and_dtype(result, expected)

        arr = np.array([long(1), long(2), long(3), None, long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        _assert_same_values_and_dtype(result, expected)

示例#5

文件： test_parsers.py 项目： MikeLindenau/pandas

    def test_convert_sql_column_bools(self):
        arr = np.array([True, False, True, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, True, False], dtype=bool)
        assert_same_values_and_dtype(result, expected)

        arr = np.array([True, False, None, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, np.nan, False], dtype=object)
        assert_same_values_and_dtype(result, expected)

示例#6

    def test_convert_sql_column_longs(self):
        arr = np.array([1L, 2L, 3L, 4L], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        assert_same_values_and_dtype(result, expected)

        arr = np.array([1L, 2L, 3L, None, 4L], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        assert_same_values_and_dtype(result, expected)

示例#7

文件： test_lib.py 项目： Casyfill/Capstone_dashboard

    def test_convert_sql_column_longs(self):
        arr = np.array([long(1), long(2), long(3), long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        _assert_same_values_and_dtype(result, expected)

        arr = np.array([long(1), long(2), long(3), None, long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        _assert_same_values_and_dtype(result, expected)

示例#8

文件： test_lib.py 项目： danielmoralesp/python-basics

    def test_convert_sql_column_bools(self):
        arr = np.array([True, False, True, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, True, False], dtype=bool)
        _assert_same_values_and_dtype(result, expected)

        arr = np.array([True, False, None, False], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([True, False, np.nan, False], dtype=object)
        _assert_same_values_and_dtype(result, expected)

示例#9

文件： test_parsers.py 项目： MikeLindenau/pandas

    def test_convert_sql_column_longs(self):
        arr = np.array([1L, 2L, 3L, 4L], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        assert_same_values_and_dtype(result, expected)

        arr = np.array([1L, 2L, 3L, None, 4L], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        assert_same_values_and_dtype(result, expected)

示例#10

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

    def test_convert_sql_column_longs(self):
        arr = np.array([long(1), long(2), long(3), long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        self.assert_numpy_array_equal(result, expected)

        arr = np.array([long(1), long(2), long(3), None, long(4)], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        self.assert_numpy_array_equal(result, expected)

示例#11

文件： test_lib.py 项目： danielmoralesp/python-basics

    def test_convert_sql_column_ints(self):
        arr = np.array([1, 2, 3, 4], dtype='O')
        arr2 = np.array([1, 2, 3, 4], dtype='i4').astype('O')
        result = lib.convert_sql_column(arr)
        result2 = lib.convert_sql_column(arr2)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        _assert_same_values_and_dtype(result, expected)
        _assert_same_values_and_dtype(result2, expected)

        arr = np.array([1, 2, 3, None, 4], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        _assert_same_values_and_dtype(result, expected)

示例#12

文件： test_io.py 项目： AlexisMignon/pandas

    def test_convert_sql_column_ints(self):
        arr = np.array([1, 2, 3, 4], dtype='O')
        arr2 = np.array([1, 2, 3, 4], dtype='i4').astype('O')
        result = lib.convert_sql_column(arr)
        result2 = lib.convert_sql_column(arr2)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        self.assert_numpy_array_equal(result, expected)
        self.assert_numpy_array_equal(result2, expected)

        arr = np.array([1, 2, 3, None, 4], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        self.assert_numpy_array_equal(result, expected)

示例#13

文件： test_infer_and_convert.py 项目： Feyi1/pandas

    def test_convert_sql_column_ints(self):
        arr = np.array([1, 2, 3, 4], dtype="O")
        arr2 = np.array([1, 2, 3, 4], dtype="i4").astype("O")
        result = lib.convert_sql_column(arr)
        result2 = lib.convert_sql_column(arr2)
        expected = np.array([1, 2, 3, 4], dtype="i8")
        self.assert_numpy_array_equal(result, expected)
        self.assert_numpy_array_equal(result2, expected)

        arr = np.array([1, 2, 3, None, 4], dtype="O")
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype="f8")
        self.assert_numpy_array_equal(result, expected)

示例#14

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

    def test_convert_sql_column_ints(self):
        arr = np.array([1, 2, 3, 4], dtype='O')
        arr2 = np.array([1, 2, 3, 4], dtype='i4').astype('O')
        result = lib.convert_sql_column(arr)
        result2 = lib.convert_sql_column(arr2)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        self.assert_numpy_array_equal(result, expected)
        self.assert_numpy_array_equal(result2, expected)

        arr = np.array([1, 2, 3, None, 4], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        self.assert_numpy_array_equal(result, expected)

示例#15

文件： test_parsers.py 项目： MikeLindenau/pandas

    def test_convert_sql_column_ints(self):
        arr = np.array([1, 2, 3, 4], dtype='O')
        arr2 = np.array([1, 2, 3, 4], dtype='i4').astype('O')
        result = lib.convert_sql_column(arr)
        result2 = lib.convert_sql_column(arr2)
        expected = np.array([1, 2, 3, 4], dtype='i8')
        assert_same_values_and_dtype(result, expected)
        assert_same_values_and_dtype(result2, expected)

        arr = np.array([1, 2, 3, None, 4], dtype='O')
        result = lib.convert_sql_column(arr)
        expected = np.array([1, 2, 3, np.nan, 4], dtype='f8')
        assert_same_values_and_dtype(result, expected)

示例#16

文件： test_io.py 项目： AlexisMignon/pandas

 def test_convert_sql_column_unicode(self):
     arr = np.array([u('1.5'), None, u('3'), u('4.2')],
                    dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([u('1.5'), np.nan, u('3'), u('4.2')],
                         dtype=object)
     self.assert_numpy_array_equal(result, expected)

示例#17

文件： test_infer_and_convert.py 项目： Feyi1/pandas

    def test_convert_sql_column_decimals(self):
        from decimal import Decimal

        arr = np.array([Decimal("1.5"), None, Decimal("3"), Decimal("4.2")])
        result = lib.convert_sql_column(arr)
        expected = np.array([1.5, np.nan, 3, 4.2], dtype="f8")
        self.assert_numpy_array_equal(result, expected)

示例#18

 def test_convert_sql_column_unicode(self):
     arr = np.array([u('1.5'), None, u('3'), u('4.2')],
                    dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([u('1.5'), np.nan, u('3'), u('4.2')],
                         dtype=object)
     self.assert_numpy_array_equal(result, expected)

示例#19

文件： test_lib.py 项目： Casyfill/Capstone_dashboard

 def test_convert_sql_column_unicode(self):
     arr = np.array([u('1.5'), None, u('3'), u('4.2')],
                    dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([u('1.5'), np.nan, u('3'), u('4.2')],
                         dtype=object)
     _assert_same_values_and_dtype(result, expected)

示例#20

文件： test_lib.py 项目： danielmoralesp/python-basics

 def test_convert_sql_column_decimals(self):
     from decimal import Decimal
     arr = np.array([Decimal('1.5'), None, Decimal('3'), Decimal('4.2')])
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     _assert_same_values_and_dtype(result, expected)

示例#21

文件： test_io.py 项目： AlexisMignon/pandas

 def test_convert_sql_column_decimals(self):
     from decimal import Decimal
     arr = np.array([Decimal('1.5'), None, Decimal('3'), Decimal('4.2')])
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     self.assert_numpy_array_equal(result, expected)

示例#22

文件： test_io.py 项目： AlexisMignon/pandas

 def test_convert_sql_column_strings(self):
     arr = np.array(['1.5', None, '3', '4.2'], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array(['1.5', np.nan, '3', '4.2'], dtype=object)
     self.assert_numpy_array_equal(result, expected)

示例#23

文件： test_lib.py 项目： danielmoralesp/python-basics

 def test_convert_sql_column_unicode(self):
     arr = np.array([u('1.5'), None, u('3'), u('4.2')], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([u('1.5'), np.nan, u('3'), u('4.2')], dtype=object)
     _assert_same_values_and_dtype(result, expected)

示例#24

文件： test_infer_and_convert.py 项目： Feyi1/pandas

 def test_convert_sql_column_floats(self):
     arr = np.array([1.5, None, 3, 4.2], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype="f8")
     self.assert_numpy_array_equal(result, expected)

示例#25

文件： test_lib.py 项目： danielmoralesp/python-basics

 def test_convert_sql_column_floats(self):
     arr = np.array([1.5, None, 3, 4.2], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     _assert_same_values_and_dtype(result, expected)

示例#26

文件： test_lib.py 项目： danielmoralesp/python-basics

 def test_convert_sql_column_strings(self):
     arr = np.array(['1.5', None, '3', '4.2'], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array(['1.5', np.nan, '3', '4.2'], dtype=object)
     _assert_same_values_and_dtype(result, expected)

示例#27

文件： test_infer_and_convert.py 项目： Feyi1/pandas

 def test_convert_sql_column_strings(self):
     arr = np.array(["1.5", None, "3", "4.2"], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array(["1.5", np.nan, "3", "4.2"], dtype=object)
     self.assert_numpy_array_equal(result, expected)

示例#28

文件： test_parsers.py 项目： MikeLindenau/pandas

 def test_convert_sql_column_decimals(self):
     from decimal import Decimal
     arr = np.array([Decimal('1.5'), None, Decimal('3'), Decimal('4.2')])
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     assert_same_values_and_dtype(result, expected)

示例#29

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

 def test_convert_sql_column_floats(self):
     arr = np.array([1.5, None, 3, 4.2], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     self.assert_numpy_array_equal(result, expected)

示例#30

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

 def test_convert_sql_column_strings(self):
     arr = np.array(['1.5', None, '3', '4.2'], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array(['1.5', np.nan, '3', '4.2'], dtype=object)
     self.assert_numpy_array_equal(result, expected)

示例#31

文件： test_parsers.py 项目： MikeLindenau/pandas

 def test_convert_sql_column_strings(self):
     arr = np.array(['1.5', None, '3', '4.2'], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array(['1.5', np.nan, '3', '4.2'], dtype=object)
     assert_same_values_and_dtype(result, expected)

示例#32

文件： test_parsers.py 项目： MikeLindenau/pandas

 def test_convert_sql_column_floats(self):
     arr = np.array([1.5, None, 3, 4.2], dtype=object)
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     assert_same_values_and_dtype(result, expected)

示例#33

文件： test_io.py 项目： LiuFang816/SALSTM_py_data

 def test_convert_sql_column_decimals(self):
     from decimal import Decimal
     arr = np.array([Decimal('1.5'), None, Decimal('3'), Decimal('4.2')])
     result = lib.convert_sql_column(arr)
     expected = np.array([1.5, np.nan, 3, 4.2], dtype='f8')
     self.assert_numpy_array_equal(result, expected)