pandas小记:pandas基本设置
2024-10-19 03:36:46
http://blog.csdn.net/pipisorry/article/details/49519545
):
print(df)
Note: 试了好久终于找到了这种设置方法!
它是这样实现的
class option_context(object): """ >>> with option_context('display.max_rows', 10, 'display.max_columns', 5): """ def __init__(self, *args): ): raise ValueError( 'Need to invoke as' 'option_context(pat, val, [(pat, val), ...)).' ) ], ])) def __enter__(self): undo = [] for pat, val in self.ops: undo.append((pat, _get_option(pat, silent=True))) self.undo = undo for pat, val in self.ops: _set_option(pat, val, silent=True) def __exit__(self, *args): if self.undo: for pat, val in self.undo: _set_option(pat, val, silent=True)
其实类似numpy数组输出精度的设置:[numpy输入输出]
pandas浮点数据输出禁用科学计数法的方式
with pd.option_context('display.float_format', lambda x: '%.3f' % x)
当然series也可以这样
Series(np.random.randn(3)).apply(lambda x: '%.3f' % x)
pandas选项和设置
List of Options
Option | Default | Function |
---|---|---|
display.chop_threshold | None | If set to a float value, all floatvalues smaller then the giventhreshold will be displayed asexactly 0 by repr and friends. |
display.colheader_justify | right | Controls the justification ofcolumn headers. used by DataFrameFormatter. |
display.column_space | 12 | No description available. |
display.date_dayfirst | False | When True, prints and parses dateswith the day first, eg 20/01/2005 |
display.date_yearfirst | False | When True, prints and parses dateswith the year first, eg 2005/01/20 |
display.encoding | UTF-8 | Defaults to the detected encodingof the console. Specifies the encodingto be used for strings returned byto_string, these are generally stringsmeant to be displayed on the console. |
display.expand_frame_repr | True | Whether to print out the full DataFramerepr for wide DataFrames acrossmultiple lines,max_columns isstill respected, but the output willwrap-around across multiple “pages”if its width exceedsdisplay.width. |
display.float_format | None | The callable should accept a floatingpoint number and return a string withthe desired format of the number.This is used in some places likeSeriesFormatter.See core.format.EngFormatter for an example. |
display.height | 60 | Deprecated. Use display.max_rows instead. |
display.large_repr | truncate | For DataFrames exceeding max_rows/max_cols,the repr (and HTML repr) can showa truncated table (the default from 0.13),or switch to the view from df.info()(the behaviour in earlier versions of pandas).allowable settings, [‘truncate’, ‘info’] |
display.line_width | 80 | Deprecated. Use display.width instead. |
display.max_columns | 20 | max_rows and max_columns are usedin __repr__() methods to decide ifto_string() or info() is used torender an object to a string. Incase python/IPython is running ina terminal this can be set to 0 andpandas will correctly auto-detectthe width the terminal and swap toa smaller format in case all columnswould not fit vertically. The IPythonnotebook, IPython qtconsole, or IDLEdo not run in a terminal and henceit is not possible to do correctauto-detection. ‘None’ value meansunlimited. |
display.max_colwidth | 50 | The maximum width in characters ofa column in the repr of a pandasdata structure. When the column overflows,a ”...” placeholder is embedded inthe output. |
display.max_info_columns | 100 | max_info_columns is used in DataFrame.infomethod to decide if per column informationwill be printed. |
display.max_info_rows | 1690785 | df.info() will usually show null-countsfor each column. For large framesthis can be quite slow. max_info_rowsand max_info_cols limit this nullcheck only to frames with smallerdimensions then specified. |
display.max_rows | 60 | This sets the maximum number of rowspandas should output when printingout various output. For example,this value determines whether therepr() for a dataframe prints outfully or just a summary repr.‘None’ value means unlimited. |
display.max_seq_items | 100 | when pretty-printing a long sequence,no more then max_seq_items willbe printed. If items are omitted,they will be denoted by the additionof ”...” to the resulting string.If set to None, the number of itemsto be printed is unlimited. |
display.memory_usage | True | This specifies if the memory usage ofa DataFrame should be displayed when thedf.info() method is invoked. |
display.mpl_style | None | Setting this to ‘default’ will modifythe rcParams used by matplotlibto give plots a more pleasing visualstyle by default. Setting this toNone/False restores the values totheir initial value. |
display.multi_sparse | True | “Sparsify” MultiIndex display (don’tdisplay repeated elements in outerlevels within groups) |
display.notebook_repr_html | True | When True, IPython notebook willuse html representation forpandas objects (if it is available). |
display.pprint_nest_depth | 3 | Controls the number of nested levelsto process when pretty-printing |
display.precision | 6 | Floating point output precision interms of number of places after thedecimal, for regular formatting as wellas scientific notation. Similar tonumpy’sprecision print option |
display.show_dimensions | truncate | Whether to print out dimensionsat the end of DataFrame repr.If ‘truncate’ is specified, onlyprint out the dimensions if theframe is truncated (e.g. not displayall rows and/or columns) |
display.width | 80 | Width of the display in characters.In case python/IPython is running ina terminal this can be set to Noneand pandas will correctly auto-detectthe width. Note that the IPython notebook,IPython qtconsole, or IDLE do not run in aterminal and hence it is not possibleto correctly detect the width. |
io.excel.xls.writer | xlwt | The default Excel writer engine for‘xls’ files. |
io.excel.xlsm.writer | openpyxl | The default Excel writer engine for‘xlsm’ files. Available options:‘openpyxl’ (the default). |
io.excel.xlsx.writer | openpyxl | The default Excel writer engine for‘xlsx’ files. |
io.hdf.default_format | None | default format writing format, ifNone, then put will default to‘fixed’ and append will default to‘table’ |
io.hdf.dropna_table | True | drop ALL nan rows when appendingto a table |
mode.chained_assignment | warn | Raise an exception, warn, or noaction if trying to use chainedassignment, The default is warn |
mode.sim_interactive | False | Whether to simulate interactive modefor purposes of testing |
mode.use_inf_as_null | False | True means treat None, NaN, -INF,INF as null (old way), False meansNone and NaN are null, but INF, -INFare not null (new way). |
pandas.set_option
pandas.set_option(pat,value) = <pandas.core.config.CallableDynamicDoc object at 0xb559f20c>
Sets the value of the specified option.
示例
[Python pandas, widen output display?]
to_csv精度设置
df_data.to_csv(outfile, index=False,
header=False, float_format='%11.6f')
[Print different precision by column with pandas.DataFrame.to_csv()]
from:http://blog.csdn.net/pipisorry/article/details/49519545
ref:pandas.core.config.get_option
最新文章
- 一分钟搞定AlloyTouch图片轮播组件
- golang笔记——array
- C实现栈和队列
- python :模态对话框
- java java.lang.NoClassDefFoundError 的解决办法
- 理解jquery的$.extend()、$.fn和$.fn.extend()
- python爬虫——爬取NUS-WIDE数据库图片
- JAX-WS(二)之使用wsimport创建WebService客户端
- SQL的表连接
- oracle修改字段类型
- Java中join()方法的理解
- 框架基础:ajax设计方案(三)--- 集成ajax上传技术 大文件/超大文件前端切割上传,后端进行重组
- Tomcat、JBOSS、WebSphere、WebLogic、Apache等技术概述
- Struts(十一):OGNL表达式(二)
- 阿里云部署Node.js项目(CentOS)
- 这篇通俗实用的Vlookup函数教程,5分钟就可以包你一学就会
- Redis Windows 64位下安装Redis详细教程
- 2019.4.14 python基础30
- linux下构建MysqlCluster集群,NDB搜索引擎
- HDU1281(KB10-D 二分图最大匹配)