* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.

1.csv파일을 엑셀에서 열면 데이터가 사라지나요? 엑셀에서 여니까 user id가 빈칸인게 좀 보여서 여쭤봅니다.

2.student_area_detail csv파일을 다운로드받고 엑셀에서 고친다음에 파이썬에서 불러오면 인코딩에 문제가 생길수 있나요?

고쳤다가 원래대로 원상복구 시키고 다시 파이썬에서 불러오기 해도 다음과 같은 오류가 뜨는데 왜 그런지 궁금합니다

3.그리고 encoding을 latin-1으로 화면 에러는 안뜨는데 출력이 이상하게 나옵니다.

이번주차 내용에서 이게 본질은 아니지만 궁금해져서 여쭤봅니다

보고 계신 화면 전체를 캡처

해 주시면, 튜터님들이 빠르

게 상황을 이해할 수 있어요.

작성한 코드 및 에러 메세지

---------------------------------------------------------------------------
UnicodeDecodeError                        Traceback (most recent call last)
<ipython-input-51-e0e3e7b64fb1> in <cell line: 30>()
     28 
     29 import pandas as pd
---> 30 sparta_data = pd.read_table('/content/students_area_detail.csv',sep=',')
     31 

10 frames

/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py in wrapper(*args, **kwargs)
    209                 else:
    210                     kwargs[new_arg_name] = new_arg_value
--> 211             return func(*args, **kwargs)
    212 
    213         return cast(F, wrapper)

/usr/local/lib/python3.10/dist-packages/pandas/util/_decorators.py in wrapper(*args, **kwargs)
    329                     stacklevel=find_stack_level(),
    330                 )
--> 331             return func(*args, **kwargs)
    332 
    333         # error: "Callable[[VarArg(Any), KwArg(Any)], Any]" has no

/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py in read_table(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, encoding_errors, dialect, error_bad_lines, warn_bad_lines, on_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)
   1287     kwds.update(kwds_defaults)
   1288 
-> 1289     return _read(filepath_or_buffer, kwds)
   1290 
   1291 

/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py in _read(filepath_or_buffer, kwds)
    603 
    604     # Create the parser.
--> 605     parser = TextFileReader(filepath_or_buffer, **kwds)
    606 
    607     if chunksize or iterator:

/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py in __init__(self, f, engine, **kwds)
   1440 
   1441         self.handles: IOHandles | None = None
-> 1442         self._engine = self._make_engine(f, self.engine)
   1443 
   1444     def close(self) -> None:

/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/readers.py in _make_engine(self, f, engine)
   1751 
   1752         try:
-> 1753             return mapping[engine](f, **self.options)
   1754         except Exception:
   1755             if self.handles is not None:

/usr/local/lib/python3.10/dist-packages/pandas/io/parsers/c_parser_wrapper.py in __init__(self, src, **kwds)
     77 
     78         kwds["dtype"] = ensure_dtype_objs(kwds.get("dtype", None))
---> 79         self._reader = parsers.TextReader(src, **kwds)
     80 
     81         self.unnamed_cols = self._reader.unnamed_cols

/usr/local/lib/python3.10/dist-packages/pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.__cinit__()

/usr/local/lib/python3.10/dist-packages/pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._get_header()

/usr/local/lib/python3.10/dist-packages/pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows()

/usr/local/lib/python3.10/dist-packages/pandas/_libs/parsers.pyx in pandas._libs.parsers.raise_parser_error()

UnicodeDecodeError: 'utf-8' codec can't decode byte 0x80 in position 141: invalid start byte