pandas 1강의 오류 질문드립니다.

[장석환]

import pandas as pd

df = pd.read_csv('경로')

print(df.groupby('성별').mean())

이렇게 적고 실행했더니, 오류가나옵니다.

Traceback (most recent call last):
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 1874, in _agg_py_fallback
    res_values = self.grouper.agg_series(ser, alt, preserve_dtype=True)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\ops.py", line 849, in agg_series
    result = self._aggregate_series_pure_python(obj, func)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\ops.py", line 877, in _aggregate_series_pure_python
    res = func(group)
          ^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 2380, in <lambda>
    alt=lambda x: Series(x).mean(numeric_only=numeric_only),
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\series.py", line 6225, in mean
    return NDFrame.mean(self, axis, skipna, numeric_only, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\generic.py", line 11992, in mean
    return self._stat_function(
           ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\generic.py", line 11949, in _stat_function
    return self._reduce(
           ^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\series.py", line 6133, in _reduce
    return op(delegate, skipna=skipna, **kwds)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\nanops.py", line 147, in f
    result = alt(values, axis=axis, skipna=skipna, **kwds)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\nanops.py", line 404, in new_func
    result = func(values, axis=axis, skipna=skipna, mask=mask, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\nanops.py", line 720, in nanmean
    the_sum = _ensure_numeric(the_sum)
              ^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\nanops.py", line 1693, in _ensure_numeric
    raise TypeError(f"Could not convert string '{x}' to numeric")
TypeError: Could not convert string 'GraduateHigh SchoolGraduateGraduateGraduateUnknownGraduateUneducatedCollegeCollegeGraduateHigh SchoolGraduateDoctorateCollegeGraduateUnknownGraduateHigh SchoolGraduateGraduateGraduateUneducatedGraduateGraduateUneducatedUnknownGraduateUneducatedHigh SchoolUnknownCollegeUnknownGraduatePost-GraduateUnknownUneducatedHigh SchoolDoctorateHigh SchoolUneducatedGraduateGraduateCollegePost-GraduateHigh SchoolGraduateUneducatedGraduateGraduateGraduateCollegeUnknownHigh SchoolUneducatedGraduateCollegeUnknownUneducatedUneducatedUneducatedUneducatedUneducatedHigh SchoolHigh SchoolGraduateGraduateUneducatedUneducatedUneducatedUneducatedCollegeHigh SchoolPost-GraduateGraduatePost-GraduateHigh SchoolGraduate' to numeric

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "c:\Users\otwel\OneDrive\바탕 화면\python\엑셀\app.py", line 11, in <module>
    print(df.groupby('성별').mean())
          ^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 2378, in mean
    result = self._cython_agg_general(
             ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 1929, in _cython_agg_general
    new_mgr = data.grouped_reduce(array_func)
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\internals\managers.py", line 1428, in grouped_reduce
    applied = sb.apply(func)
              ^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\internals\blocks.py", line 366, in apply
    result = func(self.values, **kwargs)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 1926, in array_func
    result = self._agg_py_fallback(how, values, ndim=data.ndim, alt=alt)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\otwel\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\groupby\groupby.py", line 1878, in _agg_py_fallback
    raise type(err)(msg) from err
TypeError: agg function failed [how->mean,dtype->object]

이렇게 오류가 나오는데 그 전에 나온 코드는 잘 나오는거보니까 엑셀 경로문제는 아니고, 구글colab로는 잘 실행되는데
왜 비주얼 스튜디오 코드로 실행하면 오류가 날까요 ㅜ

[codingapple]

아마 csv 파일이 이상하거나 경로가 이상하거나 둘 중 하나같습니다

[글쓴이]

글