1、 Read .txt The whole document
ww.txt The file is in the directory where the program file is located , Where files are stored elsewhere ,ww.txt You need to add a file path , Such as :E:\book1\ww.txt; What you want to return after reading is the list type , take read Change it to readlines
with open('ww.txt',encoding='utf-8') as file:
content=file.read()
print(content.rstrip()) ##rstrip() Delete the empty line at the end of the string
### Read data line by line
for line in content:
print(line)
2、 write in .txt file
The content written must be str() type , The input string needs to be followed by a newline character , Otherwise, the contents written will be on one line .
Parameters 'r' Indicates that the read model ,'w' Means write model ,'a' Indicates additional mode ( Without covering the original content , Add content to the file )'r+' Indicates read and write
filename='hh.txt'
with open(filename,'w') as file:
file.write('python\n')
file.write('java\n')
3、 Read .xlsx file
import pandas as pd
df=pd.read_excel('xxxx.xlsx',engine='openpyxl')
df.head()