When you are done with the data manipulation or generated prediction for some input data, you will want to save the data as a file, so that, you can share it with others. The most common format is a csv file or excel file.
The built in functions to_csv() and to_excel() of a pandas DataFrame can be used in order to export data as a csv or excel file.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
# Creating a DataFrame DataSample= [[10,'value1'], [20,'value2'], [30,'value3']] SimpleDataFrame=pd.DataFrame(data=DataSample, columns=['Col1','Col2']) print(SimpleDataFrame) # Exporting data frame to a csv/Excel file # Many other options are available which can be seen using dot tab option # Exporting data as a csv file SimpleDataFrame.to_csv('C:/Users/fhashmi/SimpleDataFrame.csv') # Exporting data as a excel file SimpleDataFrame.to_excel('C:/Users/fhashmi/SimpleDataFrameExcel.xlsx') |
Apart from csv and excel, a DataFrame can be exported as a JSON or pickle file format as well. These options can be seen by putting a dot(.) after any DataFrame variable and hitting the tab button.
Author Details
Lead Data Scientist
Farukh is an innovator in solving industry problems using Artificial intelligence. His expertise is backed with 10 years of industry experience. Being a senior data scientist he is responsible for designing the AI/ML solution to provide maximum gains for the clients. As a thought leader, his focus is on solving the key business problems of the CPG Industry. He has worked across different domains like Telecom, Insurance, and Logistics. He has worked with global tech leaders including Infosys, IBM, and Persistent systems. His passion to teach inspired him to create this website!