Extract csv file specific columns to list in Python

by

This looks like a problem with line endings in your code. If you’re going to be using all these other scientific packages, you may as well use Pandas for the CSV reading part, which is both more robust and more useful than just the csv module:

import pandas
colnames = ['year', 'name', 'city', 'latitude', 'longitude']
data = pandas.read_csv('test.csv', names=colnames)

If you want your lists as in the question, you can now do:

names = data.name.tolist()
latitude = data.latitude.tolist()
longitude = data.longitude.tolist()

More Related Contents:

  1. ValueError: x and y must be the same size
  2. Plot a function in python
  3. surface plots in matplotlib
  4. Python out of memory on large CSV file (numpy)
  5. Histogram Matplotlib
  6. Adding a background image to a plot
  7. How to create a density plot in matplotlib?
  8. matplotlib – extracting data from contour lines
  9. selecting across multiple columns with python pandas?
  10. Fitting a Normal distribution to 1D data
  11. how to handle an asymptote/discontinuity with Matplotlib
  12. Using numpy.genfromtxt to read a csv file with strings containing commas
  13. Problem in combining bar plot and line plot (python)
  14. Matplotlib Plot Lines with Colors Through Colormap
  15. Annotate Time Series plot in Matplotlib
  16. How to plot data from multiple two column text files with legends in Matplotlib?
  17. Matplotlib runs out of memory when plotting in a loop
  18. How to plot line (polygonal chain) with numpy/scipy/matplotlib with minimal smoothing
  19. Matplotlib: how to make imshow read x,y coordinates from other numpy arrays?
  20. ‘invalid value encountered in double_scalars’ warning, possibly numpy
  21. How to fix ‘numpy.ndarray’ object has no attribute ‘get_figure’ when plotting subplots
  22. Numpy loading csv TOO slow compared to Matlab
  23. How to update matplotlib’s imshow() window interactively?
  24. How do I plot list of tuples in Python?
  25. plotting a histogram on a Log scale with Matplotlib
  26. How to center labels in histogram plot
  27. module ‘pandas’ has no attribute ‘read_csv
  28. Adding colors to a 3d quiver plot in matplotlib
  29. How to have logarithmic bins in a Python histogram
  30. Matplotlib – Finance volume overlay

Leave a Comment