Q:

Write a NumPy program to read a CSV data file and store records in an array

hamza
Save to bookmark
|
2022-05-18
|
  178 
0

Write a NumPy program to read a CSV data file and store records in an array.

Sample CSV file: fdata.csv
Date,Open,High,Low,Close
03-10-16,774.25,776.065002,769.5,772.559998
04-10-16,776.030029,778.710022,772.890015,776.429993
05-10-16,779.309998,782.070007,775.650024,776.469971
06-10-16,779,780.47998,775.539978,776.859985
07-10-16,779.659973,779.659973,770.75,775.080017

Python programming,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

from numpy import genfromtxt
csv_data = genfromtxt('fdata.csv', dtype=['S10','float32','float32','float32','float32'], delimiter=",")
print(csv_data)

Sample Output:

[(b'Date',    nan,     nan,    nan,    nan)
 (b'03-10-16', 774.25, 776.065, 769.5 , 772.56)
 (b'04-10-16', 776.03, 778.71 , 772.89, 776.43)
 (b'05-10-16', 779.31, 782.07 , 775.65, 776.47)
 (b'06-10-16', 779.  , 780.48 , 775.54, 776.86)
 (b'07-10-16', 779.66, 779.66 , 770.75, 775.08)]

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now