test_compression.py 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211
  1. """
  2. Tests compressed data parsing functionality for all
  3. of the parsers defined in parsers.py
  4. """
  5. import os
  6. from pathlib import Path
  7. import tarfile
  8. import zipfile
  9. import pytest
  10. from pandas import DataFrame
  11. import pandas._testing as tm
  12. from pandas.tests.io.test_compression import _compression_to_extension
  13. skip_pyarrow = pytest.mark.usefixtures("pyarrow_skip")
  14. @pytest.fixture(params=[True, False])
  15. def buffer(request):
  16. return request.param
  17. @pytest.fixture
  18. def parser_and_data(all_parsers, csv1):
  19. parser = all_parsers
  20. with open(csv1, "rb") as f:
  21. data = f.read()
  22. expected = parser.read_csv(csv1)
  23. return parser, data, expected
  24. @skip_pyarrow
  25. @pytest.mark.parametrize("compression", ["zip", "infer", "zip2"])
  26. def test_zip(parser_and_data, compression):
  27. parser, data, expected = parser_and_data
  28. with tm.ensure_clean("test_file.zip") as path:
  29. with zipfile.ZipFile(path, mode="w") as tmp:
  30. tmp.writestr("test_file", data)
  31. if compression == "zip2":
  32. with open(path, "rb") as f:
  33. result = parser.read_csv(f, compression="zip")
  34. else:
  35. result = parser.read_csv(path, compression=compression)
  36. tm.assert_frame_equal(result, expected)
  37. @skip_pyarrow
  38. @pytest.mark.parametrize("compression", ["zip", "infer"])
  39. def test_zip_error_multiple_files(parser_and_data, compression):
  40. parser, data, expected = parser_and_data
  41. with tm.ensure_clean("combined_zip.zip") as path:
  42. inner_file_names = ["test_file", "second_file"]
  43. with zipfile.ZipFile(path, mode="w") as tmp:
  44. for file_name in inner_file_names:
  45. tmp.writestr(file_name, data)
  46. with pytest.raises(ValueError, match="Multiple files"):
  47. parser.read_csv(path, compression=compression)
  48. @skip_pyarrow
  49. def test_zip_error_no_files(parser_and_data):
  50. parser, _, _ = parser_and_data
  51. with tm.ensure_clean() as path:
  52. with zipfile.ZipFile(path, mode="w"):
  53. pass
  54. with pytest.raises(ValueError, match="Zero files"):
  55. parser.read_csv(path, compression="zip")
  56. @skip_pyarrow
  57. def test_zip_error_invalid_zip(parser_and_data):
  58. parser, _, _ = parser_and_data
  59. with tm.ensure_clean() as path:
  60. with open(path, "rb") as f:
  61. with pytest.raises(zipfile.BadZipFile, match="File is not a zip file"):
  62. parser.read_csv(f, compression="zip")
  63. @skip_pyarrow
  64. @pytest.mark.parametrize("filename", [None, "test.{ext}"])
  65. def test_compression(request, parser_and_data, compression_only, buffer, filename):
  66. parser, data, expected = parser_and_data
  67. compress_type = compression_only
  68. ext = _compression_to_extension[compress_type]
  69. filename = filename if filename is None else filename.format(ext=ext)
  70. if filename and buffer:
  71. request.node.add_marker(
  72. pytest.mark.xfail(
  73. reason="Cannot deduce compression from buffer of compressed data."
  74. )
  75. )
  76. with tm.ensure_clean(filename=filename) as path:
  77. tm.write_to_compressed(compress_type, path, data)
  78. compression = "infer" if filename else compress_type
  79. if buffer:
  80. with open(path, "rb") as f:
  81. result = parser.read_csv(f, compression=compression)
  82. else:
  83. result = parser.read_csv(path, compression=compression)
  84. tm.assert_frame_equal(result, expected)
  85. @skip_pyarrow
  86. @pytest.mark.parametrize("ext", [None, "gz", "bz2"])
  87. def test_infer_compression(all_parsers, csv1, buffer, ext):
  88. # see gh-9770
  89. parser = all_parsers
  90. kwargs = {"index_col": 0, "parse_dates": True}
  91. expected = parser.read_csv(csv1, **kwargs)
  92. kwargs["compression"] = "infer"
  93. if buffer:
  94. with open(csv1) as f:
  95. result = parser.read_csv(f, **kwargs)
  96. else:
  97. ext = "." + ext if ext else ""
  98. result = parser.read_csv(csv1 + ext, **kwargs)
  99. tm.assert_frame_equal(result, expected)
  100. @skip_pyarrow
  101. def test_compression_utf_encoding(all_parsers, csv_dir_path, utf_value, encoding_fmt):
  102. # see gh-18071, gh-24130
  103. parser = all_parsers
  104. encoding = encoding_fmt.format(utf_value)
  105. path = os.path.join(csv_dir_path, f"utf{utf_value}_ex_small.zip")
  106. result = parser.read_csv(path, encoding=encoding, compression="zip", sep="\t")
  107. expected = DataFrame(
  108. {
  109. "Country": ["Venezuela", "Venezuela"],
  110. "Twitter": ["Hugo Chávez Frías", "Henrique Capriles R."],
  111. }
  112. )
  113. tm.assert_frame_equal(result, expected)
  114. @skip_pyarrow
  115. @pytest.mark.parametrize("invalid_compression", ["sfark", "bz3", "zipper"])
  116. def test_invalid_compression(all_parsers, invalid_compression):
  117. parser = all_parsers
  118. compress_kwargs = {"compression": invalid_compression}
  119. msg = f"Unrecognized compression type: {invalid_compression}"
  120. with pytest.raises(ValueError, match=msg):
  121. parser.read_csv("test_file.zip", **compress_kwargs)
  122. @skip_pyarrow
  123. def test_compression_tar_archive(all_parsers, csv_dir_path):
  124. parser = all_parsers
  125. path = os.path.join(csv_dir_path, "tar_csv.tar.gz")
  126. df = parser.read_csv(path)
  127. assert list(df.columns) == ["a"]
  128. def test_ignore_compression_extension(all_parsers):
  129. parser = all_parsers
  130. df = DataFrame({"a": [0, 1]})
  131. with tm.ensure_clean("test.csv") as path_csv:
  132. with tm.ensure_clean("test.csv.zip") as path_zip:
  133. # make sure to create un-compressed file with zip extension
  134. df.to_csv(path_csv, index=False)
  135. Path(path_zip).write_text(Path(path_csv).read_text())
  136. tm.assert_frame_equal(parser.read_csv(path_zip, compression=None), df)
  137. @skip_pyarrow
  138. def test_writes_tar_gz(all_parsers):
  139. parser = all_parsers
  140. data = DataFrame(
  141. {
  142. "Country": ["Venezuela", "Venezuela"],
  143. "Twitter": ["Hugo Chávez Frías", "Henrique Capriles R."],
  144. }
  145. )
  146. with tm.ensure_clean("test.tar.gz") as tar_path:
  147. data.to_csv(tar_path, index=False)
  148. # test that read_csv infers .tar.gz to gzip:
  149. tm.assert_frame_equal(parser.read_csv(tar_path), data)
  150. # test that file is indeed gzipped:
  151. with tarfile.open(tar_path, "r:gz") as tar:
  152. result = parser.read_csv(
  153. tar.extractfile(tar.getnames()[0]), compression="infer"
  154. )
  155. tm.assert_frame_equal(result, data)