🔒 ValueError: invalid literal for int() with base 10: 'Scores' using pandas | Python | Page 1

molten mapleBOT Jan 21, 2025, 8:38 PM

#

@rain linden

Python help channel opened

Remember to:

Ask your Python question, not if you can ask or if there's an expert who can help.
Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

rain linden Jan 21, 2025, 8:41 PM

#

https://paste.pythondiscord.com/NQPQ

sudden trail Jan 21, 2025, 8:44 PM

#

!traceback

molten mapleBOT Jan 21, 2025, 8:44 PM

#

Traceback

Please provide the full traceback for your exception in order to help us identify your issue.
While the last line of the error message tells us what kind of error you got,
the full traceback will tell us which line, and other critical information to solve your problem.
Please avoid screenshots so we can copy and paste parts of the message.

A full traceback could look like:

Traceback (most recent call last):
  File "my_file.py", line 5, in <module>
    add_three("6")
  File "my_file.py", line 2, in add_three
    a = num + 3
        ~~~~^~~
TypeError: can only concatenate str (not "int") to str

If the traceback is long, use our pastebin.

sudden trail Jan 21, 2025, 8:44 PM

#

give the full thing

rain linden Jan 21, 2025, 8:45 PM

#

?

#

score_pd = pd.read_csv(score_doc, header=None, delimiter='[,]')
Traceback (most recent call last):
File "c:\Users*\OneDrive\Documents\2-pro\études\2-KIT Bachelor\VORLESUNGEN\Semester I\4-Programieren und Algoritmen I\test.py", line
8, in <module>
score_pd['Scores'] = score_pd['Scores'].astype('int64')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\generic.py", line 6643, in astype
new_data = self._mgr.astype(dtype=dtype, copy=copy, errors=errors)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\internals\managers.py", line 430, in astype
return self.apply(
^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\internals\managers.py", line 363, in apply
applied = getattr(b, f)(**kwargs)
^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\internals\blocks.py", line 758, in astype
new_values = astype_array_safe(values, dtype, copy=copy, errors=errors)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\dtypes\astype.py", line 237, in astype_array_safe
new_values = astype_array(values, dtype, copy=copy)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\dtypes\astype.py", line 182, in astype_array
values = _astype_nansafe(values, dtype, copy=copy)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users*\miniconda3\envs\pua\Lib\site-packages\pandas\core\dtypes\astype.py", line 133, in _astype_nansafe
return arr.astype(dtype, copy=True)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

#

ValueError: invalid literal for int() with base 10: 'Scores'
PS C:\Users*****\OneDrive\Documents\2-pro\études\2-KIT Bachelor\VORLESUNGEN\Semester I\4-Programieren und Algoritmen I\projekt\pua_20242025_breakout_template>

rain linden Jan 21, 2025, 8:49 PM

#

sudden trail give the full thing

if you mean the code its to big for the past

sudden trail Jan 21, 2025, 8:51 PM

#

rain linden score_pd = pd.read_csv(score_doc, header=None, delimiter='[,]') Traceback (most ...

!code

molten mapleBOT Jan 21, 2025, 8:51 PM

#

Formatting code on Discord

Here's how to format Python code on Discord:

```py
print('Hello world!')
```

These are backticks, not quotes. Check this out if you can't find the backtick key.

For long code samples, you can use our pastebin.

sudden trail Jan 21, 2025, 8:52 PM

#

also the error comes from the fact that you said there's no header

#

but there's a header

rain linden Jan 21, 2025, 8:52 PM

#

oh thanks

#

what should i put instead f none

#

because the header cant be the column names becauce it schould be integers

sudden trail Jan 21, 2025, 9:02 PM

#

rain linden what should i put instead f none

idk

#

what does it require

#

!d pandas.read_csv

molten mapleBOT Jan 21, 2025, 9:02 PM

#

pandas.read\_csv

pandas.read_csv(filepath_or_buffer, *, sep=<no_default>, delimiter=None, header='infer', names=<no_default>, index_col=None, usecols=None, dtype=None, engine=None, ...)```
Read a comma-separated values (csv) file into DataFrame.

Also supports optionally iterating or breaking of the file into chunks.

Additional help can be found in the online docs for [IO Tools](https://pandas.pydata.org/pandas-docs/stable/user_guide/io.html).

sudden trail Jan 21, 2025, 9:02 PM

#

remove the header=None and let it infer the header

rain linden Jan 21, 2025, 9:03 PM

#

oh yes it actually works thanks!!!

sudden trail Jan 21, 2025, 9:03 PM

#

!close to close the post

rain linden Jan 21, 2025, 9:08 PM

#

!close

molten mapleBOT Jan 21, 2025, 9:08 PM

#

Python help channel closed with !close

This help channel has been closed. Feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.

#🔒 ValueError: invalid literal for int() with base 10: 'Scores' using pandas