pandas读取文件参数
pd.read_csv(
filepath_or_buffer: Union[str, pathlib.Path, IO[~AnyStr]],
sep=',',
header='infer',
names=None,
columns=None,
skiprows=None,
nrows=None,
na_values=None,
keep_default_na=True,
na_filter=True,
dtype=None,
usecols=None,
index_col=None,
na_values=None,
parse_dates=False,
chunksize=None,
error_bad_lines=True,
)
pd.set_option()
pd.set_option('display.max_columns', None)
pd.set_option('display.max_columns', 5)
pd.set_option('display.max_rows', None)
pd.set_option('display.max_rows', 10)
pd.set_option('display.float_format',lambda x: '%.2f'%x)
pd.set_option('display.width', 100)
pd.set_option('precision', 1)
pd.set_option('display.max_colwidth',10)
pd.set_option('mode.chained_assignment',None)
pd.set_option('chop_threshold',20)
pd.set_option('display.html.use_mathjax',True)
pd.set_option('plotting.backend','plotly')
pd.reset_option('all')
pd.reset_option('max_rows')
pd.reset_option('max_columns')
pd.reset_option('display')
data.style.hide_index()
data.style.set_precision(2)
data.style.set_na_rep('数据缺失')
data.style.highlight_null(null_color='skyblue')
data.style.highlight_max()
data.style.highlight_min()
data.style.highlight_max(color='#F77802').highlight_min(color='#26BE49')
import seaborn as sns
cm=sns.light_palette('green',as_cmap=True)
data.style.background_gradient(cmap=cm)
data.style.set_properties(subset=['salary'],**{'color':'red'})
data.style.set_properties(**{'fontsize':'13px','background-color':'#F8F8FF','text-align':'center'})
data.style.bar(subset=['salary'],color='skyblue')
data.style.format({'createTime':lambda t:t.strftime('%Y年%m月%d日')})
pd.tO_csv(
na_rep,
index=False,
)