读文件

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
#df.to_excel('C:/Users/asus/Desktop/Python成绩.xlsx', sheet_name='dfg')
df=pd.read_excel('C:/Users/asus/Desktop/Python成绩.xlsx', index_col=None, na_values=['NA'])
print(df)
df.to_csv('C:/Users/asus/Desktop/Python成绩.csv')
df = pd.read_csv('C:/Users/asus/Desktop/Python成绩.csv')

 

 

import numpy as np
import pandas as pd
x=pd.Series([1,3,5,np.nan])
print(x)