python - make ndarray containg string and int -
how make ndarray reading csv file like
12,employed,32,happy,1 21,unemployed,31,poor,0 34,rich,45,unhapppy,0
note: file can large
output array:
[[12,"employed",32,"happy",1] [21,"unemployed",31,"poor",0] [34,"rich",45,"unhapppy",0]]
while reading csv file using np.genfromtxt(filename,delimiter = ",",dtype = none)
make 1-d array of tuples , dtype = int
make strings nan
use read_csv
first , dataframe.values
convert numpy array
:
import pandas pd df = pd.read_csv('file', header=none) print(df) 0 1 2 3 4 0 12 employed 32 happy 1 1 21 unemployed 31 poor 0 2 34 rich 45 unhapppy 0 arr = df.values print(arr) [[12 'employed' 32 'happy' 1] [21 'unemployed' 31 'poor' 0] [34 'rich' 45 'unhapppy' 0]]
Comments
Post a Comment