How to transform text file to array

Question

I have text file:

 sn we 200 8.8 99.3 10

I tried

np.genfromtxt(b[], delimiter=' ', dtype=None)

I want to get numpay array or pandas data frame with 2 columns (This is coordinates). What is the easiest way to do it? Delimiter - tab.

Magic. Thank you. I can not add you score, butthank thank you — Alex Ma
– Alex Ma, Commented Oct 19, 2017 at 12:17

cs95 · Accepted Answer · 2017-10-19 11:47:58Z

If you want a dataframe, call read_csv with delim_whitespace=True.

df = pd.read_csv('file.txt', delim_whitespace=True)

Alternatively, specify a regex-based separator:

df = pd.read_csv('file.txt', sep='\s+')

You also can retrieve a numpy array of values by querying df.values. Otherwise, you can directly retrieve a numpy array using np.loadtxt:

array = np.loadtxt('file.txt', skiprows=1)

1 Answer 1