Trying to load data from a csv file.
There's an object in file as follows:
[13 12 12 13 12 12]
dtype('O') as shown when I tried object'.values.dtype
how to convert to numeric list?
Tried astype(str), not working either.
Asked
Active
Viewed 37 times
-3
shaik moeed
- 5,300
- 1
- 18
- 54
Duke He
- 1
-
You can use `ast.literal_eval()` to parse it. – Barmar Aug 27 '23 at 06:21
-
You are asking to convert a `array` to `int`, which won't make sense as an `array` contains `int`, but can't convert `array` itself to `int`. – shaik moeed Aug 27 '23 at 06:22
-
@Barmar That object (string?) when passed to ast.literal_eval() raises SyntaxError – DarkKnight Aug 27 '23 at 06:32
-
See https://stackoverflow.com/questions/52232742/how-to-use-ast-literal-eval-in-a-pandas-dataframe-and-handle-exceptions – Barmar Aug 27 '23 at 06:34
1 Answers
0
Assuming you have that as a string then:
s = '[13 12 12 13 12 12]'
print([int(x) for x in s[1:-1].split()])
Output:
[13, 12, 12, 13, 12, 12]
DarkKnight
- 19,739
- 3
- 6
- 22