test_update.py 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  1. import numpy as np
  2. import pytest
  3. import pandas.util._test_decorators as td
  4. import pandas as pd
  5. from pandas import (
  6. DataFrame,
  7. Series,
  8. date_range,
  9. )
  10. import pandas._testing as tm
  11. class TestDataFrameUpdate:
  12. def test_update_nan(self):
  13. # #15593 #15617
  14. # test 1
  15. df1 = DataFrame({"A": [1.0, 2, 3], "B": date_range("2000", periods=3)})
  16. df2 = DataFrame({"A": [None, 2, 3]})
  17. expected = df1.copy()
  18. df1.update(df2, overwrite=False)
  19. tm.assert_frame_equal(df1, expected)
  20. # test 2
  21. df1 = DataFrame({"A": [1.0, None, 3], "B": date_range("2000", periods=3)})
  22. df2 = DataFrame({"A": [None, 2, 3]})
  23. expected = DataFrame({"A": [1.0, 2, 3], "B": date_range("2000", periods=3)})
  24. df1.update(df2, overwrite=False)
  25. tm.assert_frame_equal(df1, expected)
  26. def test_update(self):
  27. df = DataFrame(
  28. [[1.5, np.nan, 3.0], [1.5, np.nan, 3.0], [1.5, np.nan, 3], [1.5, np.nan, 3]]
  29. )
  30. other = DataFrame([[3.6, 2.0, np.nan], [np.nan, np.nan, 7]], index=[1, 3])
  31. df.update(other)
  32. expected = DataFrame(
  33. [[1.5, np.nan, 3], [3.6, 2, 3], [1.5, np.nan, 3], [1.5, np.nan, 7.0]]
  34. )
  35. tm.assert_frame_equal(df, expected)
  36. def test_update_dtypes(self):
  37. # gh 3016
  38. df = DataFrame(
  39. [[1.0, 2.0, False, True], [4.0, 5.0, True, False]],
  40. columns=["A", "B", "bool1", "bool2"],
  41. )
  42. other = DataFrame([[45, 45]], index=[0], columns=["A", "B"])
  43. df.update(other)
  44. expected = DataFrame(
  45. [[45.0, 45.0, False, True], [4.0, 5.0, True, False]],
  46. columns=["A", "B", "bool1", "bool2"],
  47. )
  48. tm.assert_frame_equal(df, expected)
  49. def test_update_nooverwrite(self):
  50. df = DataFrame(
  51. [[1.5, np.nan, 3.0], [1.5, np.nan, 3.0], [1.5, np.nan, 3], [1.5, np.nan, 3]]
  52. )
  53. other = DataFrame([[3.6, 2.0, np.nan], [np.nan, np.nan, 7]], index=[1, 3])
  54. df.update(other, overwrite=False)
  55. expected = DataFrame(
  56. [[1.5, np.nan, 3], [1.5, 2, 3], [1.5, np.nan, 3], [1.5, np.nan, 3.0]]
  57. )
  58. tm.assert_frame_equal(df, expected)
  59. def test_update_filtered(self):
  60. df = DataFrame(
  61. [[1.5, np.nan, 3.0], [1.5, np.nan, 3.0], [1.5, np.nan, 3], [1.5, np.nan, 3]]
  62. )
  63. other = DataFrame([[3.6, 2.0, np.nan], [np.nan, np.nan, 7]], index=[1, 3])
  64. df.update(other, filter_func=lambda x: x > 2)
  65. expected = DataFrame(
  66. [[1.5, np.nan, 3], [1.5, np.nan, 3], [1.5, np.nan, 3], [1.5, np.nan, 7.0]]
  67. )
  68. tm.assert_frame_equal(df, expected)
  69. @pytest.mark.parametrize(
  70. "bad_kwarg, exception, msg",
  71. [
  72. # errors must be 'ignore' or 'raise'
  73. ({"errors": "something"}, ValueError, "The parameter errors must.*"),
  74. ({"join": "inner"}, NotImplementedError, "Only left join is supported"),
  75. ],
  76. )
  77. def test_update_raise_bad_parameter(self, bad_kwarg, exception, msg):
  78. df = DataFrame([[1.5, 1, 3.0]])
  79. with pytest.raises(exception, match=msg):
  80. df.update(df, **bad_kwarg)
  81. def test_update_raise_on_overlap(self):
  82. df = DataFrame(
  83. [[1.5, 1, 3.0], [1.5, np.nan, 3.0], [1.5, np.nan, 3], [1.5, np.nan, 3]]
  84. )
  85. other = DataFrame([[2.0, np.nan], [np.nan, 7]], index=[1, 3], columns=[1, 2])
  86. with pytest.raises(ValueError, match="Data overlaps"):
  87. df.update(other, errors="raise")
  88. def test_update_from_non_df(self):
  89. d = {"a": Series([1, 2, 3, 4]), "b": Series([5, 6, 7, 8])}
  90. df = DataFrame(d)
  91. d["a"] = Series([5, 6, 7, 8])
  92. df.update(d)
  93. expected = DataFrame(d)
  94. tm.assert_frame_equal(df, expected)
  95. d = {"a": [1, 2, 3, 4], "b": [5, 6, 7, 8]}
  96. df = DataFrame(d)
  97. d["a"] = [5, 6, 7, 8]
  98. df.update(d)
  99. expected = DataFrame(d)
  100. tm.assert_frame_equal(df, expected)
  101. def test_update_datetime_tz(self):
  102. # GH 25807
  103. result = DataFrame([pd.Timestamp("2019", tz="UTC")])
  104. with tm.assert_produces_warning(None):
  105. result.update(result)
  106. expected = DataFrame([pd.Timestamp("2019", tz="UTC")])
  107. tm.assert_frame_equal(result, expected)
  108. def test_update_with_different_dtype(self, using_copy_on_write):
  109. # GH#3217
  110. df = DataFrame({"a": [1, 3], "b": [np.nan, 2]})
  111. df["c"] = np.nan
  112. if using_copy_on_write:
  113. df.update({"c": Series(["foo"], index=[0])})
  114. else:
  115. df["c"].update(Series(["foo"], index=[0]))
  116. expected = DataFrame({"a": [1, 3], "b": [np.nan, 2], "c": ["foo", np.nan]})
  117. tm.assert_frame_equal(df, expected)
  118. @td.skip_array_manager_invalid_test
  119. def test_update_modify_view(self, using_copy_on_write):
  120. # GH#47188
  121. df = DataFrame({"A": ["1", np.nan], "B": ["100", np.nan]})
  122. df2 = DataFrame({"A": ["a", "x"], "B": ["100", "200"]})
  123. df2_orig = df2.copy()
  124. result_view = df2[:]
  125. df2.update(df)
  126. expected = DataFrame({"A": ["1", "x"], "B": ["100", "200"]})
  127. tm.assert_frame_equal(df2, expected)
  128. if using_copy_on_write:
  129. tm.assert_frame_equal(result_view, df2_orig)
  130. else:
  131. tm.assert_frame_equal(result_view, expected)
  132. def test_update_dt_column_with_NaT_create_column(self):
  133. # GH#16713
  134. df = DataFrame({"A": [1, None], "B": [pd.NaT, pd.to_datetime("2016-01-01")]})
  135. df2 = DataFrame({"A": [2, 3]})
  136. df.update(df2, overwrite=False)
  137. expected = DataFrame(
  138. {"A": [1.0, 3.0], "B": [pd.NaT, pd.to_datetime("2016-01-01")]}
  139. )
  140. tm.assert_frame_equal(df, expected)