Python Forum
converting dataframe to int numpy array
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
converting dataframe to int numpy array
#1
i have a text file with 3 lines :
1,2,3
1,2,4
1,2,5


import pandas as pd
import numpy as np
df= pd.read_fwf("sample.txt",header =None)
df= df.to_numpy()
print("df:",df)
running my code gives me a result of
df:[['1,2,3']
['1,2,4']
['1,2,5']]
how to convert it to integers?
i want the output to be
[[1,2,3]
[1,2,4]
[1,2,5]]
Reply
#2
Use reaf_csv().
>>> import pandas as pd
>>> import numpy as np

>>> df = pd.read_csv("sample.txt", header=None, sep=',')
>>> df = df.to_numpy()
>>> df
array([[1, 2, 3],
       [1, 2, 4],
       [1, 2, 5]], dtype=int64)

>>> df[0]
array([1, 2, 3], dtype=int64)
>>> df[0][2]
3
>>> type(df[0][2])
<class 'numpy.int64'>
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  [Numpy] How to store different data type in one numpy array? water 7 545 Mar-26-2024, 02:18 PM
Last Post: snippsat
  reshaping 2D numpy array paul18fr 3 1,009 Jan-03-2023, 06:45 PM
Last Post: paul18fr
  Numpy returns "TypeError: unsupported operand type(s) for *: 'numpy.ufunc' and 'int'" kalle 2 2,604 Jul-19-2022, 06:31 AM
Last Post: paul18fr
  Dataframe with array value Tibovdv 2 2,430 Mar-24-2021, 07:22 PM
Last Post: Tibovdv
  Numpy array BrianPA 13 4,955 Jan-23-2021, 09:36 AM
Last Post: Serafim
  How to fill datetime64 field in numpy structured array? AlekseyPython 0 2,267 Oct-20-2020, 08:17 AM
Last Post: AlekseyPython
  Adding data in 3D array from 2D numpy array asmasattar 0 2,218 Jul-23-2020, 10:55 AM
Last Post: asmasattar
  Replacing sub array in Numpy array ThemePark 5 4,166 Apr-01-2020, 01:16 PM
Last Post: ThemePark
  How to prepare a NumPy array which include float type array elements subhash 0 1,911 Mar-02-2020, 06:46 AM
Last Post: subhash
  numpy.where array search for string in just one coordinate adetheheat 1 2,278 Jan-09-2020, 07:09 PM
Last Post: paul18fr

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020