python - change pandas 0.13.0 "print dataframe" to print dataframe like in earlier versions -


in new version 0.13.0 of pandas, dataframe df printed in 1 long list of numbers using

df

or

print df

instead of overview, before, possible using

df.info()

is possible change default 'df' or 'print df' command show :

in [12]: df.info() <class 'pandas.core.frame.dataframe'> datetimeindex: 4319 entries, 2010-02-18 00:00:00 2010-03-13 23:15:00 data columns (total 2 columns): qint    4319  non-null values qhea    4319  non-null values dtypes: float32(2)

again instead of:

in [11]: df out[11]:                                   qint         qhea 2010-02-18 00:00:00         169.666672     0.000000 2010-02-18 00:15:00         152.000000    -0.000000 2010-02-18 00:15:00         152.000000    -0.000000 2010-02-18 00:30:00         155.000000    -0.000000 2010-02-18 00:30:04         155.063950    -0.000000 2010-02-18 00:30:04         155.063950 -1136.823364 2010-02-18 00:45:00         169.666672  4587.430176 2010-02-18 01:00:00         137.333328  4532.890137 2010-02-18 01:00:00         137.333328  4532.890137 2010-02-18 01:15:00         177.000000  4464.479980 2010-02-18 01:15:00         177.000000  4464.479980 2010-02-18 01:30:00         169.666672  4391.839844 2010-02-18 01:30:00         169.666672  4391.839844 2010-02-18 01:45:00         155.000000  4313.049805 2010-02-18 01:45:00         155.000000  4313.049805 2010-02-18 02:00:00         144.666672  4230.100098 2010-02-18 02:15:00         162.333328  4144.819824 2010-02-18 02:15:00         162.333328  4144.819824 2010-02-18 02:30:00         177.000000  4059.689941 2010-02-18 02:45:00         144.666672  3987.149902 2010-02-18 02:45:00         144.666672  3987.149902 2010-02-18 03:00:00         155.000000  3924.629883 2010-02-18 03:00:00         155.000000  3924.629883 2010-02-18 03:15:00         162.333328  3865.129883 2010-02-18 03:15:00         162.333328  3865.129883 2010-02-18 03:30:00         162.333328  3811.050049 2010-02-18 03:30:00         162.333328  3811.050049 2010-02-18 03:45:00         152.000000  3765.590088 2010-02-18 03:45:00         152.000000  3765.590088 2010-02-18 04:00:00         162.333328  3735.080078 2010-02-18 04:15:00         162.333328  3703.169922 2010-02-18 04:15:00         162.333328  3703.169922 2010-02-18 04:30:00         144.666672  3673.139893 2010-02-18 04:45:00         169.666672  3647.100098 2010-02-18 04:45:00         169.666672  3647.100098 2010-02-18 05:00:00         162.333328  3622.129883 2010-02-18 05:15:00         155.000000  3594.159912 2010-02-18 05:15:00         155.000000  3594.159912 2010-02-18 05:30:00         159.333328  3569.699951 2010-02-18 05:30:00         159.333328  3569.699951 2010-02-18 05:45:00         147.666672  3551.179932 2010-02-18 05:45:00         147.666672  3551.179932 2010-02-18 06:00:00         177.000000  3531.669922 2010-02-18 06:00:00         177.000000  3531.669922 2010-02-18 06:15:00         159.333328  3514.679932 2010-02-18 06:15:00         159.333328  3514.679932 2010-02-18 06:30:00         155.000000  3499.669922 2010-02-18 06:30:00         155.000000  3499.669922 2010-02-18 06:45:00         155.000000  3485.320068 2010-02-18 06:45:00         155.000000  3485.320068 2010-02-18 06:59:54.750000  162.291245    19.999992 2010-02-18 06:59:54.750000  162.291245     0.000000 2010-02-18 07:00:00         162.333328     0.000000 2010-02-18 07:00:00         162.333328     0.000000 2010-02-18 07:15:00         166.666672     0.000000 2010-02-18 07:15:00         166.666672     0.000000 2010-02-18 07:30:00         155.000000     0.000000 2010-02-18 07:30:00         155.000000     0.000000 2010-02-18 07:45:00         155.000000     0.000000 2010-02-18 07:45:00         155.000000     0.000000                                    ...          ...  [4319 rows x 2 columns]

set

pd.options.display.large_repr = 'info'

the default of v.0.13 'truncate'.

in [93]: df = pd.dataframe(np.arange(4319*2).reshape(4319,2))  in [94]: pd.options.display.large_repr = 'info'  in [95]: df out[95]:  <class 'pandas.core.frame.dataframe'> int64index: 4319 entries, 0 4318 data columns (total 2 columns): 0    4319 non-null int32 1    4319 non-null int32 dtypes: int32(2)

i found searching string 'info()' in output of:

in [65]: pd.set_option?

to make default behavior interactive sessions:

if haven't set already, define environment variable pythonstartup /home/user/bin/startup.py

then edit/create /home/user/bin/startup.py contain like

import pandas pd pd.options.display.large_repr = 'info'

now, whenever start interactive python session, startup.py file executed, you'll have access pandas through pd variable, , large_repr default 'info'.


-

Comments

Post a Comment

Popular posts from this blog

php - regexp cyrillic filename not matches -

i take list of files php glob(."*.pdf") . files have cyrillic names. example: ООО «Рога и копыта» then load company names database , try find them in file names: preg_match("/$firm_name/ui", $file_name, $match); i have problem: firms if $firm_name visually similar $file_name , preg_match says there no match. mb_detect_encoding both variables return utf-8. there problem in file name, or maybe there encoding or something, can not understand, ask help. upd: $file_name='ООО «Рога и копыта»'; preg_match("/... .Рога и копыта./ui", $file_name, $match); as result, ОО «Рога и копыта» , 1 О missing
Read more

c# - OpenXML hanging while writing elements -

Image
i have program pulls data database, caches file , exports data multiple formats (excel, excel 2003, csv). i'm using openxml sdk 2.0 excel work. these export processes run in parallel (using parallel.foreach ), , amount of data can pretty large - e.g. csvs 800mb. during these larger exports, i've noticed writing of xml documents hang. instance, if have 8 exporting in parallel, @ point "pause". hang around same point: //this.writer openxmlwriter created worksheetpart. this.writer.writeelement(new cell() { cellvalue = new cellvalue(value), datatype = cellvalues.string }); when happens, pause debugger (vs2013 in case) , notice threads blocking around same portion of code - bit deeper in openxml sdk - stem call openxmlwriter.writeelement . i dug through source using justdecompile didn't find answers. appears there intermediary stream in use writing isolated storage , is, reason, blocking. underlying stream each of these filestream . here screenshot ...
Read more

sql - Select Query has unexpected multiple records (MS Access) -

i may tired, can't seem figure out happening. have 2 queries. query 1 has 10 fields. query 2 has 5 fields. fields 1 through 3 same in both queries. trying write select query , simple add field 5 query2 query1 result should query1 additional field (query2.field5). i join first 3 fields both queries , choose select records in query1 , in query2 match. don't know sql, use query designer. expect same number of records have query 1 instead have 3 times or more. can tell me doing wrong. tried reversing joins still seem same records. thanks in advance. here query: the fields in common divisionname , supplierid = vendorid , commodityname . select [part revenue exposed query p1].divisionname, [part revenue exposed query p1].commodityname, [part revenue exposed query p1].suppliername, [part revenue exposed query p1].partnumber, [part revenue exposed query p1].partdescription, [part revenue exposed query p1].bucode, ...
Read more