Hands-On Artificial Intelligence for IoT

Working with CSV files with the NumPy module

The NumPy module provides two functions for reading values from CSV files: np.loadtxt() and np.genfromtxt().

An example of np.loadtxt is as follows:

arr = np.loadtxt('temp.csv', skiprows=1, usecols=(2,3), delimiter=',')arr

The preceding code reads columns 3 and 4 from the file that we created earlier, and saves them in a 9 × 2 array as follows:

array([[2.58 , 0.136],
       [2.552, 0.1  ],
       [2.55 , 0.1  ],
       [2.55 , 0.1  ],
       [2.554, 0.1  ],
       [2.55 , 0.1  ],
       [2.534, 0.096],
       [2.484, 0.   ],
       [2.468, 0.   ]])

The np.loadtxt() function cannot handle CSV files with missing data. For instances where data is missing, np.genfromtxt() can be used. Both of these functions offer many more arguments; details can be found ...