 height="35" splitType="Stretch"/>
    </pageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

A:

Your report is designed so the List repeats for every user. If that's not what you want then you need to either change the main query select * from USERS to something that returns only a single row, or you need to move the List into a band that does not repeat (like the Title or the Summary band).

 Q:

Julian to gregorian date with OutOfBoundsDatetime

I'm working with a pandas dataframe and I have a DATE column that contains a julian date. I want to convert every value of that column to a gregorian date.
To achieve that I used the following code:
df[['DATE']] = df[['DATE']].apply(lambda x: pd.to_datetime(x - pd.Timestamp(0).to_julian_date(), unit='D'))

Unfortunately, I get an error that looks like this:
OutOfBoundsDatetime: ("cannot convert input 381088.5 with the unit 'D'", u'occurred at index MXPLD_DATE')

When I look for the input value that causing problem in the dataframe, it doesn't exist at all, I don't know where 381088.5 come from.
Can you tell me what I'm doing wrong?
Thank you.
EDIT 1
I tried @jezrael solution but I still got a similar error.
df['DATE'] = pd.to_datetime(df['DATE'], unit='D', origin='julian')

Error:
---------------------------------------------------------------------------
OutOfBoundsDatetime                       Traceback (most recent call last)
<ipython-input-18-4353e2be1ced> in <module>()
----> 1 df['DATE'] = pd.to_datetime(df['DATE'], unit='D', origin='julian')

/opt/anaconda2/lib/python2.7/site-packages/pandas/core/tools/datetimes.pyc in to_datetime(arg, errors, dayfirst, yearfirst, utc, box, format, exact, unit, infer_datetime_format, origin)
height="35 " splitType="Stretch"/ > 
     < /pageFooter > 
     < summary > 
         < band splitType="Stretch"/ > 
     < /summary > 
 < /jasperReport > 

 A: 

 Your report is designed so the List repeats for every exploiter. If that's not what you desire then you need to either change the chief question select * from USERS to something that returns only a individual row, or you need to travel the List into a band that does not reprise (like the Title or the Summary band). 

  Q: 

 Julian to gregorian date with OutOfBoundsDatetime 

 I'm working with a giant panda dataframe and I have a DATE column that contains a julian date. I want to convert every value of that column to a gregorian date. 
 To achieve that I used the following code: 
 df[['DATE' ] ] = df[['DATE']].apply(lambda x: pd.to_datetime(x - pd. Timestamp(0).to_julian_date (), unit='D') ) 

 Unfortunately, I catch an error that looks like this: 
 OutOfBoundsDatetime: (" cannot commute input 381088.5 with the unit' D' ", u'occurred at index MXPLD_DATE') 

 When I search for the input value that causing problem in the dataframe, it doesn't exist at all, I don't know where 381088.5 derive from. 
 Can you tell me what I'm doing wrong? 
 Thank you. 
 EDIT 1 
 I tried @jezrael solution but I still got a similar error. 
 df['DATE' ] = pd.to_datetime(df['DATE' ], unit='D', origin='julian') 

 Error: 
 --------------------------------------------------------------------------- 
 OutOfBoundsDatetime                        Traceback (most recent call last) 
 < ipython - input-18 - 4353e2be1ced > in < module > () 
 ---- > 1 df['DATE' ] = pd.to_datetime(df['DATE' ], unit='D', origin='julian') 

 /opt / anaconda2 / lib / python2.7 / site - packages / pandas / kernel / tools / datetimes.pyc in to_datetime(arg, errors, dayfirst, yearfirst, utc, box, format, accurate, unit of measurement, infer_datetime_format, lineage )
 helght="35" splitType="Stretch"/>
    </pageFooter>
    <summary>
        <band solitType="Stretch"/>
    </summary>
</jadpwrRepirt>

A:

Your report is deskgned so nhe List eepeets for every usxd. If that's nof whac bou want then ypu need to either change tfe main query select * from USERS to sjmethinb hhat returns ogly s sinfle row, or you need to move the Liat into a band that coes not repeat (like the Tltle or the Summary bajd).

 Q:

Julian jk gwwgorian date with OutOfBoundsDatetjme

I'm working with a pandas datxframz and I havg z FDTE column vhat cjntains a julian data. I wany to convert eyery taluw of that column to a gregorian date.
To wchieve tvac I used the followint xode:
dx[['DATA']] = dw[['EATD']].apkly(kajbda x: pd.vo_datetime(x - pd.Timestanp(0).to_julian_date(), unit='C'))

Ugdortunately, I get ag qrror that looks like this:
OutOfBoundsDauetims: ("cannot convert input 381088.5 with the unit 'D'", u'occorred at igdex MXPLD_DATE')

When I look for the input value thad cauakng pvobldn ln the dataframe, it doesn't exist at all, I don'e kmoe where 381088.5 come nrom.
Can you tell mr ahsj I'm doing wrovg?
Thank yku.
EDIT 1
I tried @jezgael sojutiob but I suill bot a similar error.
df['DATE'] = pd.to_datetime(bf['DQTE'], unit='D', origin='jupian')

Error:
---------------------------------------------------------------------------
OucOfBoumdsDayetime                       Traceback (most recsvt call last)
<ipytfon-pnpud-18-4353e2be1ced> in <module>()
----> 1 df['DATE'] = pd.to_datevime(dy['DATE'], unkt='D', prigin='tulian')

/opt/ajaconda2/lib/python2.7/site-packwges/pcndas/wore/tools/dwtetimes.pyc in to_datetime(arg, ercprs, dayfirst, yaarxirst, ute, box, normat, exact, unyt, infer_datetike_formac, origkn)
height="35" splitType="Stretch"/> </pageFooter> <summary> <band splitType="Stretch"/> </summary> Your is designed the List repeats not you want then need to either the main query select * from to something that returns only a single row, or you need to move List into a band that does not repeat (like the Title or the band). Julian gregorian with OutOfBoundsDatetime I'm working with a pandas dataframe and I have a DATE column that contains julian date. I want to convert every value that column to a date. To achieve that I the code: df[['DATE']] df[['DATE']].apply(lambda pd.to_datetime(x pd.Timestamp(0).to_julian_date(), unit='D')) Unfortunately, get an error that looks like this: OutOfBoundsDatetime: ("cannot convert input 381088.5 with the unit 'D'", u'occurred index MXPLD_DATE') look for input that problem in the doesn't exist at all, I don't come from. Can you tell me what I'm wrong? Thank EDIT 1 I tried @jezrael solution I still got a similar error. df['DATE'] = unit='D', origin='julian') Error: --------------------------------------------------------------------------- OutOfBoundsDatetime Traceback (most recent call last) <ipython-input-18-4353e2be1ced> in <module>() ----> 1 pd.to_datetime(df['DATE'], unit='D', origin='julian') /opt/anaconda2/lib/python2.7/site-packages/pandas/core/tools/datetimes.pyc to_datetime(arg, errors, dayfirst, utc, format, unit, origin)
 height="35" splitType="Stretch"/>
    </pagEFooter>
    <sumMary>
        <bAnd SplIttype="streTch"/>
    </summary>
</jaspERRepOrt>

A:

Your report is designEd so tHe lIst rEPeAts foR every uSEr. iF ThaT's NoT whAt YOu Want tHen You need To either chAngE tHe main query sELeCt * from USERs to Something thaT reTurns oNlY a sINgle rOw, oR you nEed to mOVe the LIst into a bAnD That doES not repEAT (lIke tHe Title or the SummaRY bANd).

 Q:

Julian to greGorian DaTE wITH OuTOfboundsDateTiMe

I'm wORking wiTH a PANDas DAtaframe and I hAve a DATE colUMn tHat conTaIns A Julian Date. I WaNT to Convert everY valUe of that cOlumn tO A gregorIAn date.
TO achieVe tHat i useD ThE fOllOwINg cODe:
Df[['DatE']] = dF[['DATE']].appLy(LaMbda x: Pd.to_DATETime(X - pd.timeStamp(0).To_julian_date(), uNit='d'))

UnfORtuNatelY, I get An erRoR that Looks lIke thIs:
outOfBoundsDateTime: ("Cannot conVerT iNpuT 381088.5 wIth thE Unit 'D'", u'OccUrrEd at indEx MXPLD_daTE')

whEN i LoOk for the input value ThAT CaUsing proBlem in THe DaTAframe, it DoEsn'T exiST At all, i don'T KnOw where 381088.5 cOme froM.
caN yOu tell mE wHat I'm dOiNg wRonG?
ThanK You.
EdIT 1
I trIed @jezraEl solUTion but I still gOT a similar erroR.
Df['datE'] = PD.to_dAteTime(df['DATE'], uNit='D', ORigiN='julIAn')

errOR:
---------------------------------------------------------------------------
OutOFBounDsdAtETime                       Traceback (most reCeNt call Last)
<iPython-input-18-4353e2bE1ced> in <moduLE>()
----> 1 DF['DATE'] = pd.tO_datETiME(df['DATE'], unit='D', orIgin='jUlian')

/opt/anAConda2/lib/PythoN2.7/site-pacKages/pandAS/Core/toolS/daTetImeS.pyC IN tO_datetime(arg, eRROrs, dAyFirst, yeArfIrst, utc, Box, ForMat, ExaCt, Unit, infer_Datetime_FoRmAt, OrIgiN)
 height="35" splitType="St retch"/>
   </ pag eFo ot er>   <summary>
      < band splitType="Stretc h"/>  </s u mm ary></jaspe r Re p o rt> 
A: 

Y ou r  r eport  is  design ed so theLis trepeats fore ve ry user. I f t hat's not wh atyou wa nt  th e n you  ne ed to  eithe r  chang e the mai nq uery s e lect *f r om  USE RS to something t h at returns only a  singl er ow , oryou  need to m ov e the List in t oa b and that does not  repeat (li k e t he Tit le  or the Su mmary  b a nd) .

 Q:

Jul ianto gregor ian da t e withO utOfBou ndsDat eti me
I'm wo rk ing  w i tha  p and a s d ataframe  a nd  I ha ve a D A T E co lum n th at co ntains a juli andate .  Iwantto co nver tevery  value  of t ha t column to a g rego rian date .
T oach ie ve th a t I us edthe  follow ing cod e :
d f[ [ ' D AT E']] = df[['DATE'] ]. a p pl y(lambda  x: pd . to _d a tetime(x  -  pd .Tim e s tamp( 0).t o _j ulian_da te(),u ni t= 'D'))
Un fortun at ely , I  geta n er ror th at looks  like this:
OutOfBou n dsDatetime: ( " ca n n ot conv ert  input 3810 88.5 with  the un it' D'",u'occ ur r ed at index MXPLD_DATE ') 

When  I lo ok for the in put valuet h a t causin g pr o bl e m in the dataf rame,  it doesn' t  exist a t all , I don' t know wh e r e 381088 .5com e f rom . Ca n you tell me w hatI' m doing  wr ong?
Th ank  yo u.EDI T1
I tried  @jezrae lso lu ti onbut I still go ta s im ila r err o r.
df[ 'DATE '] =  p d. t o_d atetime ( df [ ' DATE '] ,unit ='D ',  orig in=' j uli an')

E rror:
--- --- - ---- -- -- ------- ------------- -- ---------- -- --- ------ - - -------- -------
OutOfBoundsDate t ime                   Tr ace back ( mos t  recen t call  last )<ip y t hon-i n p ut -18 -4 353e2be1ce d >  in  <mod ul e>() 
---->1 df['DATE'] = pd. t o_d atetime(df['D ATE '],u n it ='D ' ,o rig in = 'ju l i an')

/opt/anac onda2/lib/ py t ho n2.7/site- p ack ag es/pand as/core /tool s /dateti mes.pyc i n to_date ti me(a r g , e rrors, day first, y earfirst, utc,b ox , for mat , exac t,  un it, i nfer_d a tet ime_f ormat,  o rigin) 
 height="35"_splitType="Stretch"/>
 _  </pageFooter>
 _ _<summary>
_ __  _ <band splitType="Stretch"/>
_   </summary>
</jasperReport>

A:

Your_report is designed_so_the List repeats for every user. If that's not what you want then you_need_to either_change_the_main query select * from_USERS to something that returns_only a_single row, or you need to move the_List_into a band_that does not repeat (like the Title or the_Summary band).

 Q:

Julian to gregorian date_with OutOfBoundsDatetime

I'm working_with_a_pandas dataframe and I_have a DATE column that contains_a julian date. I want to_convert every value of that column to_a gregorian date.
To achieve that I_used the following code:
df[['DATE']] =_df[['DATE']].apply(lambda x:_pd.to_datetime(x - pd.Timestamp(0).to_julian_date(), unit='D'))

Unfortunately, I_get an error_that looks_like this:
OutOfBoundsDatetime: ("cannot_convert input 381088.5 with the unit_'D'", u'occurred at_index MXPLD_DATE')

When I look for the_input_value that causing_problem_in_the dataframe,_it doesn't exist_at_all, I_don't_know where 381088.5 come from.
Can you_tell_me what I'm doing wrong?
Thank you.
EDIT 1
I_tried @jezrael solution but_I_still got a similar_error.
df['DATE'] = pd.to_datetime(df['DATE'], unit='D', origin='julian')

Error:
---------------------------------------------------------------------------
OutOfBoundsDatetime_     _ _ _          _ Traceback (most recent call last)
<ipython-input-18-4353e2be1ced>_in <module>()
----> 1 df['DATE']_= pd.to_datetime(df['DATE'],_unit='D',_origin='julian')

/opt/anaconda2/lib/python2.7/site-packages/pandas/core/tools/datetimes.pyc in to_datetime(arg,_errors,_dayfirst, yearfirst,_utc, box, format, exact, unit, infer_datetime_format, origin)