Tuesday 22 June 2021

EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS || SAVE DATAFRAME IN PANDAS

EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS 

Firstly, we are importing an excel sheet as a DataFrame,
 
import pandas as pd

st = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")

sd = pd.DataFrame(st)

print(st)



Making some changes in the dataframe


st['Total']=st['Hindi']+st['English'] +st['Science'] +st['History']+st['Mathematics']






Now, exporting the DataFrame as Excel, CSV and Text File


sd.to_excel("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.xlsx")

sd.to_csv("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.csv")

sd.to_csv("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.txt" ,sep = "\t")





As you can see we have created three new files.






Join us: https://t.me/jupyter_python

0 Comments:

Post a Comment

Popular Posts

Categories

AI (27) Android (24) AngularJS (1) Assembly Language (2) aws (17) Azure (7) BI (10) book (4) Books (112) C (77) C# (12) C++ (82) Course (60) Coursera (176) coursewra (1) Cybersecurity (22) data management (11) Data Science (85) Data Strucures (6) Deep Learning (9) Django (6) Downloads (3) edx (2) Engineering (14) Excel (13) Factorial (1) Finance (5) flutter (1) FPL (17) Google (18) Hadoop (3) HTML&CSS (46) IBM (25) IoT (1) IS (25) Java (92) Leet Code (4) Machine Learning (43) Meta (18) MICHIGAN (4) microsoft (3) Pandas (3) PHP (20) Projects (29) Python (719) Python Coding Challenge (155) Questions (2) R (70) React (6) Scripting (1) security (3) Selenium Webdriver (2) Software (17) SQL (40) UX Research (1) web application (8)

Followers

Person climbing a staircase. Learn Data Science from Scratch: online program with 21 courses