Remove titles in csv string

Question

I'm new to python, this is a fairly simple question. I have a .csv string and I want to remove the first line with the titles:

Date,Open,High,Low,Close,Volume,Adj Close
2016-01-08,1.658,1.70,1.625,1.639,15383400,1.639
2016-01-07,1.64,1.645,1.56,1.642,28015800,1.642
2016-01-06,1.68,1.734,1.672,1.71,15199200,1.71

What's the simplest way to do this? This is how I'm reading the data:

import requests
import csv
import json

theURL = 'http://ichart.yahoo.com/table.csv?s=REC.OL&a=0&b=1&c=2016&d=0&e=10&f=2016'
r = requests.get(theURL)
text = r.text

reader = csv.DictReader(text, fieldnames=("Date", "Open", "High", "Low", "Close", "Volume", "Adj Close"))
jsonText = json.dumps([row for row in reader])

Thanks in advance for your comments!

What do you mean, remove the first line? – PyNEwbie Jun 30 '16 at 18:01 — PyNEwbie, Jun 30 '16 at 18:01
How are you currently reading it in? – Nick Jun 30 '16 at 18:02 — Nick, Jun 30 '16 at 18:02

score 0 · Accepted Answer · answered Jun 30 '16 at 18:12

If you want to remove the first line, you can do something like this:

string = """Date,Open,High,Low,Close,Volume,Adj Close
2016-01-08,1.658,1.70,1.625,1.639,15383400,1.639
2016-01-07,1.64,1.645,1.56,1.642,28015800,1.642
2016-01-06,1.68,1.734,1.672,1.71,15199200,1.71"""

string = string.split('\n')[1:]

This removes the first line and stores each consecutive line in a list. You can iterate over the list and get your string back or just keep the list for easier use.

Exactly what I wanted, thank you – Rafael Sanchez Jun 30 '16 at 18:20 — Rafael Sanchez, Jun 30 '16 at 18:20

Remove titles in csv string

1 Answers1