Enterprise Docs
Search…
Exporting data
How to export data to CSV files with Python
Using dcdcpy you can easily generate a CSV file with any data you like that's available from the Data Connector.
Our dcdcpy Python library makes all data from the Data Connector easily available as a Pandas dataFrame. The code snippet below is all you need in order to dump all the DataCamp courses to a CSV file called
courses.csv1
from dcdcpy.dcdcpy import DataConnector
2
dc = DataConnector()
3
courses = dc.course_dim();
4
courses.to_csv('courses.csv')
Copied!
This way you can easily set up a recurring task to automatically generate an up to date CSV file of all the courses available on DataCamp whenever you need them.
Ofcourse there is more you can do. Say for example you only want the
id, title and technology columns in the CSV. Using the filter method on the DataFrame lets you select any columns you want. 1
from dcdcpy.dcdcpy import DataConnector
2
dc = DataConnector()
3
courses = dc.course_dim().filter(['course_id', 'title', 'technology']);
4
courses.to_csv('courses.csv')
Copied!
Going one step further, if you would only be interested in Python courses, with a simple extra step you can select only the Python courses.
1
from dcdcpy.dcdcpy import DataConnector
2
dc = DataConnector()
3
courses = dc.course_dim().filter(['course_id', 'title', 'technology']);
4
courses = courses[courses['technology'] == 'Python']
5
courses.to_csv('courses.csv')
Copied!
Last modified 2mo ago
Copy link