How to capture a CSV file and read it into a Pandas Dataframe?

[David Shi]

Hi, Skip,
This is something very different.
New thinking and methods are needed.
Try to click on the following link
European Commission : CORDIS : Search : Results page


| 
| 
| 
|  |  |

 |

 |
| 
|  | 
European Commission : CORDIS : Search : Results page
European Commission |  |

 |

 |



Is there a way to capture the file?
Regards.
David
 

    On Wednesday, 5 April 2017, 17:19, Skip Montanaro <skip.montanaro at gmail.com> wrote:
 

 I'm not positive, but try passing response to read_csv() instead of reading the bytes yourself.
Skip
On Apr 5, 2017 10:38 AM, "David Shi via Python-list" <python-list at python.org> wrote:



I tried the following codes:
import urllib2response = urllib2.urlopen('http:// cordis.europa.eu/search/ result_en?q=uk&format=csv') myCSV = response.read()
myFile = pd.read_csv(myCSV)

but, it did not work well.
Can any one help?
Regards.
David
--
https://mail.python.org/ mailman/listinfo/python-list