(macOS)[python] Numpy Excel 다루기 - 1 : .csv 읽기

Intro

 - Editor : sublime text3

 - python 3.9.1

 - numpy 1.19.4

 

Data

-300	300	1	-301	302	2	4
-250	300	1	-251	302	2	4
-200	300	1	-201	302	2	4
-150	300	1	-151	302	2	4
-100	300	1	-101	302	2	4
-50	300	1	-51	302	2	4
0	300	1	-1	302	2	4
50	300	1	49	302	2	4
100	300	1	99	302	2	4
150	300	1	149	302	2	4
200	300	1	199	302	2	4
250	300	1	249	302	2	4
300	300	1	299	302	2	4

 

Directory Tree

.

├── data

   └── test1.csv

└── test_read.py

 

# -*- coding: utf-8 -*-

import os
import numpy as np


#### dir base
fpath_base = './data'

#### file_name, sheet_name
fnames = ('test1.csv','test1.xlsx')
shnames = ('Sheet1','Sheet2','Sheet3')

#### file_dir_base
fpath_bases = [os.path.join(fpath_base,fname) for fname in fnames]

#### file_read_csv : no text, just number
data_csv = np.loadtxt(fpath_bases[0], delimiter=",")
print(data_csv)

 

실행결과 : ----*REPL*[python]----

[[-300.  300.    1. ...  302.    2.    4.]
 [-250.  300.    1. ...  302.    2.    4.]
 [-200.  300.    1. ...  302.    2.    4.]
 ...
 [ 200.  300.    1. ...  302.    2.    4.]
 [ 250.  300.    1. ...  302.    2.    4.]
 [ 300.  300.    1. ...  302.    2.    4.]]

***Repl Closed***