I am trying to truncate data from a csv file that i got from the interwebs using python

[Shriman Sonti]

I have a code that downloads a csv file from a website, but it won't download this specific csv file because it has some missing spaces in the file 

This is my code:

    import requests

    import pandas as pd

    from io import StringIO

    outfile = r'C:\Users\spkso\Desktop\out\myfile.csv'

    url = 'https://www.misoenergy.org/Library/Repository/Market%20Reports/20161230_da_expost_lmp.csv'

    csv = requests.get(url)

    df = pd.read_csv(StringIO (csv.text))

   df.to_csv(outfile)

Any suggestions would be much obliged 

Thank You

    

[Paul Hobson]

Try:

pandas.read_csv('https://www.misoenergy.org/Library/Repository/Market Reports/20161230_da_expost_lmp.csv')

--
You received this message because you are subscribed to the Google Groups "PyData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.