Python Forum
Load specific set of Rows CSV
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Load specific set of Rows CSV
#1
Hello,

I have a CSV file that looks something like this:

strings
strings
data (float)
data (float)
data (float)
strings
strings
strings
data (float)
data (float)
...
etc

The file contains many rows and two columns and I would like to load e.g. all the columns in row 1 to 5 in a numpy array. Additionally, I would like to store e.g. row 6-144 in another array (all those rows are data) etc. Is there a way to do this? I tried things like np.loadtxt, csv.reder and pandas.read_csv but I must be missing something. I would prefer to do it without using a loop due to the time consumption when the files get very large.

If someone use MATLAB and know the python way to do this, here's a hint:
MATRIX = dlmread('FILE.csv',',',[5 0 144 1]);
This stores row 5 to 144 and colum 0 to 1 if a matlab code.

Thanks in advance!
Reply


Messages In This Thread
Load specific set of Rows CSV - by Marcuslang - Jun-30-2018, 07:18 PM
RE: Load specific set of Rows CSV - by Larz60+ - Jun-30-2018, 10:14 PM
RE: Load specific set of Rows CSV - by Marcuslang - Jul-01-2018, 07:22 AM
RE: Load specific set of Rows CSV - by Larz60+ - Jul-01-2018, 07:35 AM
RE: Load specific set of Rows CSV - by buran - Jul-01-2018, 07:52 AM
RE: Load specific set of Rows CSV - by Larz60+ - Jul-01-2018, 01:58 PM
RE: Load specific set of Rows CSV - by Marcuslang - Jul-01-2018, 05:35 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Write specific rows from pandas dataframe to csv file pradeepkumarbe 3 5,567 Oct-18-2018, 09:33 PM
Last Post: volcano63
  Removing rows at random based on the value of a specific column Mr_Keystrokes 4 5,681 Aug-24-2018, 11:15 AM
Last Post: Mr_Keystrokes
  How to filter specific rows from large data file Ariane 7 8,296 Jun-29-2018, 02:43 PM
Last Post: gontajones

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020