Since version [v0.13.0 (January 3, 2014)][1] of Pandas you can use the `date_format` parameter of the [to_csv][2] method:

    df.to_csv(filename, date_format=&#39;%Y%m%d&#39;)


  [1]: https://pandas.pydata.org/pandas-docs/stable/whatsnew/v0.13.0.html?highlight=date_format
  [2]: http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_csv.html

You could use [`strftime`](http://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior) to save these as separate columns:

    df[&#39;date&#39;] = df[&#39;datetime&#39;].apply(lambda x: x.strftime(&#39;%d%m%Y&#39;))
    df[&#39;time&#39;] = df[&#39;datetime&#39;].apply(lambda x: x.strftime(&#39;%H%M%S&#39;))

and then be specific about which columns to export to csv:

    df[[&#39;date&#39;, &#39;time&#39;, ... ]].to_csv(&#39;df.csv&#39;)

To export as a timestamp, do this:

    df.to_csv(filename, date_format=&#39;%s&#39;)

The `%s` format is [not documented in python/pandas][1] but works in this case.

I found the `%s` from [the dates formats of ruby][2]. [Strftime doc for C here][3]

Note that the timestamp miliseconds format `%Q` does not work with pandas (you&#39;ll have a litteral `%Q` in the field instead of the date). I caried my sets with python 3.6 and pandas 0.24.1


  [1]: https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior
  [2]: https://apidock.com/ruby/DateTime/strftime
  [3]: http://man7.org/linux/man-pages/man3/strftime.3.html

My android program has a `class A`, which has two `static inner class`. They are found to be stripped from `.dex` after applying proguard.


    public class A{

      ...
      static class B{
        ...
      }

      static class C{
        ...
      }
    }

I have put the following lines in proguard.flags, but seem no luck. 

    -keep class com.xxx.A
    -keep class com.xxx.A$*

Any hint?



Android proguard, keep inner class

I&#39;m using Selenium WebDriver (Java) and TestNG to do some testing on a website I created. In this website, I also have JavaScript and in some of the functions, it returns values and also outputs values to the browser console through `console.log()`.

**I was wondering if there is an easy way for Selenium WebDriver to access some of this JavaScript information so I can perform assertions using TestNG.**

I&#39;m quite new to Selenium but I understand that you can do something like:

    WebDriver driver = new ChromeDriver();
    driver.findElement(By.id(&quot;btn&quot;)).click();

So is there anything similar I can do using `WebDriver` to read the JavaScript on the site?

----------

Clarification
-------------

It looks like people are making the assumption that I&#39;m trying to &quot;execute&quot; JavaScript code through Selenium.

Thats not the case. Instead, I&#39;m trying to store already-defined JavaScript variable using Selenium.

Basically, I want Selenium to be able to grab the JavaScript variable&#39;s value, store it locally, and then do an assertion test on it.

----------

Attempt 1
---------

Say I have the following JS code for my website:

    $(document).ready(function() {
    	var foo = $(#&quot;input-field-val&quot;).val();
    
    	function returnFoo() {
    		return foo;
    	}
    });

From what I&#39;ve reading and understanding, in my seperate Selenium test file (Selenium.java), I should be able to do something like this?:

    public class Selenium {
    	WebDriver driver = new FirefoxDriver();
    	JavascriptExecutor js = (JavascriptExecutor) driver;
    
    	@Test
    	public void testSample() {
    		driver.get(&quot;www.mywebsite.com&quot;);
    		js.executeScript(&quot;alert(returnFoo());&quot;);
    	}
    }

I do something similar to what&#39;s above but no alert box pops up. Instead, I get an error message:

    Exception in thread &quot;main&quot; org.openqa.selenium.WebDriverException: ReferenceError: returnFoo is not defined

I&#39;m pretty sure I&#39;m not understanding what it means when its said that the JS variable 

&gt; should not be part of a closure or local variable

I have also tried defining a global variable above the `$(document).ready(function()...` and setting is within `function returnFoo()` but still doesn&#39;t work.

----------

Attempt 2
---------

I&#39;ve moved both `foo` and `returnFoo()` outside of the `$(document).ready(function()...`. That has fixed `ReferenceError` message that I was getting in *Attempt 1* above.

I hav also given `foo` a value so my JS code looks something like this:

    var foo = &quot;Selenium test run&quot;;
    
    $(document).ready(function() {
    ...
    });
    
    function returnFoo() {
        return foo;
    }

Now, I&#39;m having a tough time assigning the return of `returnFoo()` to a local variable within my Selenium test. Here&#39;s what I&#39;ve attempted:

    public static void main(String[] args) {
            WebDriver driver = new FirefoxDriver();
            JavascriptExecutor js = (JavascriptExecutor) driver;
    
            driver.get(&quot;http://localhost:8080/HTML5TestApp/prod.html&quot;);
            Object val = js.executeScript(&quot;window.returnFoo();&quot;);
            System.out.println(val);
        } 

But the console display `null` instead of the actual value of **&quot;Selenium test run&quot;**.

Attempt 2 - SOLUTION
-----------------

It looks like if I do `Object val = js.executeScript(&quot;alert(returnFoo());&quot;);` I get the value of `foo`.


----------

SOLUTION
--------

So here&#39;s the solution I&#39;ve come up w/ to my problem thanks to the solution by Martin Foot below.

In my JavaScript file, I created a `var` and a setter/getter function like so:

**index.js**

    var seleniumGlobal;
    
    $(document).ready(function() {
    ...
    )};
    
    function setSG(toSet) {
    	seleniumGlobal = toSet;
    }
    
    function getSG() {
    	return seleniumGlobal;
    }

**SampleTest.java**

    // Do all the necessary imports

    public class SampleTest {
    	WebDriver driver = new FirefoxDriver();
    	JavascriptExecutor js = (JavascriptExecutor) driver;
    
    	@Test
    	public void testPrintVal() {
    		String sgVal = (String) js.executeScript(&quot;alert(getSG());&quot;);
    		Assert.assertEquals(&quot;new value for seleniumGlobal&quot;, sgVal);
    	}
    }

So whenever some code in my JavaScript sets my `seleniumGlobal` variable through the setter method, I can call it through my Selenium test and do assertions on it.

This is probably not the most efficient way to do but if someone else has a better solution, please let me know.


Reading JavaScript variables using Selenium WebDriver

The default output format of `to_csv()` is:

    12/14/2012  12:00:00 AM

I cannot figure out how to output only the date part with specific format:

    20121214

or date and time in two separate columns in the csv file:

    20121214,  084530

The documentation is too brief to give me any clue as to how to do these. Can anyone help?

How to specify date format when using pandas.to_csv?

The default output format of <code>to_csv()</code> is:
<pre><code class="hljs">12/14/2012 12:00:00 AM
</code></pre>
I cannot figure out how to output only the date part with specific format:
<pre><code class="hljs">20121214
</code></pre>
or date and time in two separate columns in the csv file:
<pre><code class="hljs">20121214, 084530
</code></pre>
The documentation is too brief to give me any clue as to how to do these. Can anyone help?

Is there any way to directly replace all groups using regex syntax?

The normal way:

    re.match(r&quot;(?:aaa)(_bbb)&quot;, string1).group(1)

But I want to achieve something like this:

    re.match(r&quot;(\d.*?)\s(\d.*?)&quot;, &quot;(CALL_GROUP_1) (CALL_GROUP_2)&quot;)

I want to build the new string instantaneously from the groups the Regex just captured.

Python Regex instantly replace groups

I get the following error when trying to run Django from the command line.

    File manage.py, line 8, in &lt;module&gt;
    &#160;&#160;&#160;&#160; from django.core.management import execute_from_command_line
    ImportError: No module named django.core.management
    

Any ideas on how to solve this?



Django - &quot;no module named django.core.management&quot;

I am writing a script in Python (.py file) and I am using Matplotlib to plot an array.
I want to add a legend with a formula to the plot, but I haven&#39;t been able to do it.
I have done this before in IPython or the terminal. In this case, writing something like this:

    legend(ur&#39;$The_formula$&#39;)
worked perfectly. However, this doesn&#39;t work when I call my .py script from the terminal/IPython.

How do I write a Latex formula in the legend of a plot using Matplotlib inside a .py file?

I have a pandas DataFrame like this:

                        a         b
    2011-01-01 00:00:00 1.883381  -0.416629
    2011-01-01 01:00:00 0.149948  -1.782170
    2011-01-01 02:00:00 -0.407604 0.314168
    2011-01-01 03:00:00 1.452354  NaN
    2011-01-01 04:00:00 -1.224869 -0.947457
    2011-01-01 05:00:00 0.498326  0.070416
    2011-01-01 06:00:00 0.401665  NaN
    2011-01-01 07:00:00 -0.019766 0.533641
    2011-01-01 08:00:00 -1.101303 -1.408561
    2011-01-01 09:00:00 1.671795  -0.764629

Is there an efficient way to find the &quot;integer&quot; index of rows with NaNs? In this case the desired output should be `[3, 6]`.

Find integer index of rows with NaN in pandas dataframe

Is there a way in Python to pass optional parameters to a function while calling it and in the function definition have some code based on &quot;only if the optional parameter is passed&quot;




Is there a way to pass optional parameters to a function?

Sorry just getting into Pandas, this seems like it should be a very straight forward question. How can I use the `isin(&#39;X&#39;)` to remove rows that **are in** the list `X`? In R I would write `!which(a %in% b)`.


Remove rows not .isin(&#39;X&#39;)

I&#39;m trying to multiply two existing columns in a pandas Dataframe (orders_df) - Prices (stock close price) and Amount (stock quantities) and add the calculation to a new column called &#39;Value&#39;. For some reason when I run this code, all the rows under the &#39;Value&#39; column are positive numbers, while some of the rows should be negative. Under the Action column in the DataFrame there are seven rows with the &#39;Sell&#39; string and seven with the &#39;Buy&#39; string.

    for i in orders_df.Action:
     if i  == &#39;Sell&#39;:
      orders_df[&#39;Value&#39;] = orders_df.Prices*orders_df.Amount
     elif i == &#39;Buy&#39;:
      orders_df[&#39;Value&#39;] = -orders_df.Prices*orders_df.Amount)


Please let me know what i&#39;m doing wrong !

I want to multiply two columns in a pandas DataFrame and add the result into a new column

I am trying to write a Pandas dataframe (or can use a numpy array) to a mysql database using MysqlDB . MysqlDB doesn&#39;t seem understand &#39;nan&#39; and my database throws out an error saying nan is not in the field list. I need to find a way to convert the &#39;nan&#39; into a NoneType.

Any ideas? 

Replacing Pandas or Numpy Nan with a None to use with MysqlDB

How can I export a list of DataFrames into one Excel spreadsheet?  
The docs for [`to_excel`](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html) state:

&gt;Notes  
If passing an existing ExcelWriter object, then the sheet will be added
to the existing workbook.  This can be used to save different
DataFrames to one workbook

&gt;`writer = ExcelWriter(&#39;output.xlsx&#39;)`  
`df1.to_excel(writer, &#39;sheet1&#39;)`  
`df2.to_excel(writer, &#39;sheet2&#39;)`  
`writer.save()`

Following this, I thought I could write a function which saves a list of DataFrames to one spreadsheet as follows:

    from openpyxl.writer.excel import ExcelWriter
    def save_xls(list_dfs, xls_path):
        writer = ExcelWriter(xls_path)
        for n, df in enumerate(list_dfs):
            df.to_excel(writer,&#39;sheet%s&#39; % n)
        writer.save()

However (with a list of two small DataFrames, each of which can save `to_excel` individually), an exception is raised *(Edit: traceback removed)*:

    AttributeError: &#39;str&#39; object has no attribute &#39;worksheets&#39;

Presumably I am not calling [`ExcelWriter`](http://www.nullege.com/codes/search?cq=openpyxl.writer.excel.ExcelWriter) correctly, how should I be in order to do this?

Save list of DataFrames to multisheet Excel spreadsheet

I am trying to add a feature of csv download option in my website. It should convert the html table present in the website in to csv content and make it downloadable. Ive been searching through internet for a good plugin and found some usefule ones like [http://www.dev-skills.com/export-html-table-to-csv-file/][1]  But it uses php script to do the download part. I was wondering if there is a pure javascript library available to do this feature using server side softwares like node.js without the use of php??

[1]:https://web.archive.org/web/20131008192222/http://www.dev-skills.com/export-html-table-to-csv-file/

Export HTML table to CSV using vanilla javascript

I have a tabular data which I need to export to csv without using any external plugin or API. I used the `window.open` method passing the MIME types but faced issues like below:

[https://stackoverflow.com/questions/15918173/how-to-determine-whether-microsoft-excel-or-open-office-is-installed-on-the-syst][1]

The code should be independent of the fact that what is being installed on the system, i.e. OpenOffice or Microsoft Excel. I believe CSV is the format which can be expected to show in both the editors.

## CODE

        &lt;html&gt;
    
    &lt;head&gt;
    &lt;script src=&quot;http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js&quot;&gt;&lt;/script&gt;  
    
    &lt;script type=&quot;text/JavaScript&quot;&gt;
    $(document).ready(function(){
    	$(&quot;#btnExport&quot;).click(function(e) {
    		var msg = GetMimeTypes();
    		//OpenOffice
    		window.open(&#39;data:application/vnd.oasis.opendocument.spreadsheet,&#39; + $(&#39;#dvData&#39;).html());
    		//MS-Excel
    		window.open(&#39;data:application/vnd.ms-excel,&#39; + $(&#39;#dvData&#39;).html());
    		//CSV
    		window.open(&#39;data:application/csv,charset=utf-8,&#39; + $(&#39;#dvData&#39;).html());
    		e.preventDefault();
    	});
    });
    
    function GetMimeTypes () {
    	var message = &quot;&quot;;
    		// Internet Explorer supports the mimeTypes collection, but it is always empty
    	if (navigator.mimeTypes &amp;&amp; navigator.mimeTypes.length &gt; 0) {
    		var mimes = navigator.mimeTypes;
    		for (var i=0; i &lt; mimes.length; i++) {
    			message += &quot;&lt;b&gt;&quot; + mimes[i].type + &quot;&lt;/b&gt; : &quot; + mimes[i].description + &quot;&lt;br /&gt;&quot;;
    		}
    	}
    	else {
    		message = &quot;Your browser does not support this &quot;;
    	   //sorry!
    	}
    
    	return ( message);
    }
    &lt;/script&gt;
    
    &lt;/head&gt;
    &lt;body&gt;
    &lt;div id=&quot;dvData&quot;&gt;
    &lt;table&gt;
        &lt;tr&gt;
            &lt;th&gt;Column One &lt;/th&gt;
            &lt;th&gt;Column Two&lt;/th&gt;
            &lt;th&gt;Column Three&lt;/th&gt;
        &lt;/tr&gt;
        &lt;tr&gt;
            &lt;td&gt;row1 Col1&lt;/td&gt;
            &lt;td&gt;row1 Col2&lt;/td&gt;
            &lt;td&gt;row1 Col3&lt;/td&gt;
       &lt;/tr&gt;
       &lt;tr&gt;
            &lt;td&gt;row2 Col1&lt;/td&gt;
            &lt;td&gt;row2 Col2&lt;/td&gt;
            &lt;td&gt;row2 Col3&lt;/td&gt;
       &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;row3 Col1&lt;/td&gt;
            &lt;td&gt;row3 Col2&lt;/td&gt;
            &lt;td&gt;row3 Col3&lt;/td&gt;  
       &lt;/tr&gt;
    &lt;/table&gt;
    &lt;/div&gt;
    &lt;br/&gt;
    &lt;input type=&quot;button&quot; id=&quot;btnExport&quot; value=&quot; Export Table data into Excel &quot; /&gt;
    
    &lt;/body&gt;

## Errors

**CSV:** Unrecognised over the browsers

**ODS &amp; Excel:**  is working but I am not able to find which one to generate when system is having an excel installed or openoffice installed?

**IE** version 8 : it is totally not working, opens in a new window and as below screenshot.

![enter image description here][2]




  [1]: https://stackoverflow.com/questions/15918173/how-to-determine-whether-microsoft-excel-or-open-office-is-installed-on-the-syst
  [2]: http://i.stack.imgur.com/Ms7KU.png

Export to CSV using jQuery and HTML

I am a novice programmer and I searched a lot about my question but couldn&#39;t find a helpful solution or tutorial about this.

My goal is I have a PHP array and the array elements are showing in a list on the page.

I want to add an option, so that if a user wants, he/she can create a CSV file with array elements and download it.

I don&#39;t know how to do this. I have searched a lot too. But yet to find any helpful resource.

Please provide me some tutorial or solution or advice to implement it by myself. As I&#39;m a novice please provide easy to implement solutions.

My array looks like: 

    Array
    (
        [0] =&gt; Array
            (
                [fs_id] =&gt; 4c524d8abfc6ef3b201f489c
                [name] =&gt; restaurant
                [lat] =&gt; 40.702692
                [lng] =&gt; -74.012869
                [address] =&gt; new york
                [postalCode] =&gt; 
                [city] =&gt; NEW YORK
                [state] =&gt; ny
                [business_type] =&gt; BBQ Joint
                [url] =&gt; 
            )
     
    )


How to create and download a csv file from php script?

If we were on a nodeJS server, we could write a header, set a mime type, and send it:

    res.header(&quot;Content-Disposition&quot;, &quot;attachment;filename=&quot;+name+&quot;.csv&quot;); 
    res.type(&quot;text/csv&quot;);
    res.send(200, csvString);

and because of the headers, the browser will create a download for the named csv file.

When useful data is generated in a browser, one solution to getting it in a CSV file is to use ajax, upload it to the server, (perhaps optionally save it there) and get the server to send it back with these headers to become a csv download back at the browser.

However, I would like a 100% browser solution that does not involve ping-pong with the server.

So it occurred to me that one could open a new window and try to set the header with a META tag equivalent.  

But this doesn&#39;t work for me in recent Chrome.  

I do get a new window, and it contains the csvString, but does not act as a download.

I guess I expected to get either a download in a bottom tab or a blank new window with a download in a bottom tab.  

I&#39;m wondering if the meta tags are correct or if other tags are also needed.

Is there a way to make this work without punting it to the server?

[JsFiddle for Creating a CSV in the Browser (not working - outputs window but no download)][1]

    var A = [[&#39;n&#39;,&#39;sqrt(n)&#39;]];  // initialize array of rows with header row as 1st item
    for(var j=1;j&lt;10;++j){ A.push([j, Math.sqrt(j)]) }
    var csvRows = [];
    for(var i=0,l=A.length; i&lt;l; ++i){
        csvRows.push(A[i].join(&#39;,&#39;));   // unquoted CSV row
    }
    var csvString = csvRows.join(&quot;\n&quot;);
    console.log(csvString);
    var csvWin = window.open(&quot;&quot;,&quot;&quot;,&quot;&quot;);
    csvWin.document.write(&#39;&lt;meta name=&quot;content-type&quot; content=&quot;text/csv&quot;&gt;&#39;);
    csvWin.document.write(&#39;&lt;meta name=&quot;content-disposition&quot; content=&quot;attachment;  filename=data.csv&quot;&gt;  &#39;);
    csvWin.document.write(csvString);

  [1]: http://jsfiddle.net/7SDXv/8/




Export javascript data to CSV file without server interaction

I need to export javascript array to excel file and download it I&#39;m doing it in this code.     data is a javascript object array. 

	var csvContent = &quot;data:text/csv;charset=utf-8,&quot;;
	data.forEach(function(dataMember, index)
	{
		dataString = dataMember.join(&quot;,&quot;);
		csvContent += index &lt; data.length ? dataString+ &quot;\n&quot; : dataString;
	}); 

	var encodedUri = encodeURI(csvContent);
	var link = document.createElement(&quot;a&quot;);
	link.setAttribute(&quot;href&quot;, encodedUri);
	link.setAttribute(&quot;download&quot;, &quot;upload_data&quot; + (new Date()).getTime() + &quot;.csv&quot;);
	link.click();

All this stuff works fine till I have string properties that have non-english characters, like spanish, arabic or hebrew. How can I make an export with all this non-ASCII values?

Javascript to csv export encoding issue

How can I convert a DataFrame column of strings (in ***dd/mm/yyyy*** format) to datetimes?

Convert DataFrame column type from string to datetime

Is it possible to display a `DateTime` value in **dd/mm/yyyy** format with the help of `HTML Helper` methods in `Asp.NET MVC`? I tried to do this by using some formats in `@Html.LabelFor` and adding some annotations to the related property like below but it does not make any sense. Any help to solve this problem would be appreciated.

**Model:** 

    [DataType(DataType.Date)]
    [DisplayFormat(DataFormatString = &quot;{0:dd/MM/yyyy}&quot;, ApplyFormatInEditMode = true)]
    public Nullable&lt;System.DateTime&gt; RegistrationDate { get; set; }


Display DateTime value in dd/mm/yyyy format in Asp.NET MVC

Could anyone please suggest me how to convert date from this `1387843200000` format into this `24/12/2013` **inside my controller**?

Just FYI my dates are stored in this way &amp; when binding to edit form with `input type=&quot;date&quot;` field is not being populated at all. 

**[#Plunker demo here.][1]** 

EditCtrl


    app.controller(&quot;EditCtrl&quot;, [ &quot;$scope&quot;, &quot;$filter&quot;, &quot;db&quot; function ($scope, $filter, db){
    
    	// this gets me an item object
    	var item = db.readItem();
    
    	// item date = 1387843200000
    	// this returns undefined 
    	item.date = $filter(&#39;date&#39;)(date[ item.date, &quot;dd/MM/yyyy&quot;]);
    
    }]);

Edit.html - template 

    &lt;form name=&quot;editForm&quot; class=&quot;form-validate&quot;&gt;
    		
    		&lt;div class=&quot;form-group&quot;&gt;
    			&lt;label for=&quot;date&quot;&gt;Event date.&lt;/label&gt;
    			&lt;input type=&quot;date&quot; class=&quot;form-control&quot; ng-model=&quot;event.date&quot; id=&quot;date&quot; required /&gt;
    		&lt;/div&gt;
    
    		&lt;a href=&quot;#/&quot; class=&quot;btn btn-danger &quot;&gt;Cancel&lt;/a&gt;
    		&lt;button id=&quot;addEvent&quot; class=&quot;btn btn-primary pull-right&quot; ng-disabled=&quot;isClean() || editForm.$invalid&quot; ng-click=&quot;saveEvent()&quot;&gt;Save event.&lt;/button&gt;
    
    	&lt;/form&gt;


  [1]: http://plnkr.co/edit/akLekgX7b1rcaMg6B9rI?p=preview

AngularJS - convert dates in controller

I have a date with the format `Sun May 11,2014`. How can I convert it to `2014-05-11` using JavaScript?

&lt;!-- begin snippet: js hide: false console: true babel: false --&gt;

&lt;!-- language: lang-js --&gt;

    function taskDate(dateMilli) {
        var d = (new Date(dateMilli) + &#39;&#39;).split(&#39; &#39;);
        d[2] = d[2] + &#39;,&#39;;

        return [d[0], d[1], d[2], d[3]].join(&#39; &#39;);
    }

    var datemilli = Date.parse(&#39;Sun May 11,2014&#39;);
    console.log(taskDate(datemilli));

&lt;!-- end snippet --&gt;

The code above gives me the same date format, `sun may 11,2014`. How can I fix this?




Format JavaScript date as yyyy-mm-dd

I recently moved to Java 8 to, hopefully, deal with local and zoned times more easily.

However, I&#39;m facing an, in my opinion, simple problem when parsing a simple date.

    public static ZonedDateTime convertirAFecha(String fecha) throws Exception {
    	DateTimeFormatter formatter = DateTimeFormatter.ofPattern(
    			ConstantesFechas.FORMATO_DIA).withZone(
    			obtenerZonaHorariaServidor());
    
    	ZonedDateTime resultado = ZonedDateTime.parse(fecha, formatter);
    	return resultado;
    }

In my case:

* fecha is &#39;15/06/2014&#39;
* ConstantesFechas.FORMATO_DIA is &#39;dd/MM/yyyy&#39;
* obtenerZonaHorariaServidor returns ZoneId.systemDefault()

So, this is a simple example. However, the parse throws this exception:

&gt; java.time.format.DateTimeParseException: Text &#39;15/06/2014&#39; could not
&gt; be parsed: Unable to obtain ZonedDateTime from TemporalAccessor:
&gt; {},ISO resolved to 2014-06-15 of type java.time.format.Parsed

Any tips? I&#39;ve been trying different combinations of parsing and using TemporalAccesor, but without any luck so far.

Unable to obtain ZonedDateTime from TemporalAccessor using DateTimeFormatter and ZonedDateTime in Java 8

Please consider the following

    $ R --vanilla

    &gt; as.Date(&quot;01 Jan 2000&quot;)
    Error in charToDate(x) :
        character string is not in a standard unambiguous format

But that date clearly *is* in a standard unambiguous format. Why the error message?

Worse, an ambiguous date is apparently accepted without warning or error and then read incorrectly!

    &gt; as.Date(&quot;01/01/2000&quot;)
    [1] &quot;0001-01-20&quot;

I&#39;ve searched and found 28 other questions in the [R] tag containing this error message. All with solutions and workarounds involving specifying the format, iiuc. This question is different in that I&#39;m asking where are the standard unambiguous formats defined anyway, and can they be changed?  Does everyone get these messages or is it just me? Perhaps it is locale related?

In other words, is there a better solution than needing to specify the format?

[29 questions containing &quot;[R] standard unambiguous format&quot;][1]

    &gt; sessionInfo()
    R version 2.15.2 (2012-10-26)
    Platform: x86_64-w64-mingw32/x64 (64-bit)
    
    locale:
    [1] LC_COLLATE=English_United Kingdom.1252
    [2] LC_CTYPE=English_United Kingdom.1252
    [3] LC_MONETARY=English_United Kingdom.1252
    [4] LC_NUMERIC=C
    [5] LC_TIME=English_United Kingdom.1252
    
    attached base packages:
    [1] stats     graphics  grDevices utils     datasets  methods   base

  [1]: https://stackoverflow.com/search?q=%5Br%5D%20standard%20unambiguous%20format

What are the &quot;standard unambiguous date&quot; formats for string-to-date conversion in R?

**Goal:** Find the `local time` and `UTC time offset` then construct the URL in following format.

Example URL: `/Actions/Sleep?duration=2002-10-10T12:00:00−05:00`

The format is based on the [W3C recommendation][1]. The documentation says:

&gt; For example, 2002-10-10T12:00:00−05:00 (noon on 10 October 2002, 
&gt;     Central Daylight Savings Time as well as Eastern Standard Time in the U.S.) 
&gt;     is equal to 2002-10-10T17:00:00Z, five hours later than 2002-10-10T12:00:00Z.

So based on my understanding, I need to find my local time by `new Date()` then use `getTimezoneOffset()` function to compute the difference then attach it to the end of string.

1. Get local time with `format`

    ```
    var local = new Date().format(&quot;yyyy-MM-ddThh:mm:ss&quot;); // 2013-07-02T09:00:00
    ```

2. Get UTC time offset by hour

    ```
    var offset = local.getTimezoneOffset() / 60; // 7
    ```

3. Construct URL (time part only)

    ```
    var duration = local + &quot;-&quot; + offset + &quot;:00&quot;; // 2013-07-02T09:00:00-7:00
    ```

The above output means my local time is 2013/07/02 9am and difference from UTC is 7 hours (UTC is 7 hours ahead of local time)

So far it seems to work but what if `getTimezoneOffset()` returns negative value like -120?

I&#39;m wondering how the format should look like in such case because I cannot figure out from W3C documentation.


  [1]: http://www.w3.org/TR/xmlschema11-2/#dateTime

How to ISO 8601 format a Date with Timezone Offset in JavaScript?

This docs mention `moment.ISO_8601` as a formatting option (from 2.7.0 - http://momentjs.com/docs/#/parsing/special-formats/), but neither of these work (even 2.7.0):

    var date = moment();
    date.format(moment.ISO_8601); // error
    moment.format(date, moment.ISO_8601); // error

(http://jsfiddle.net/b3d6uy05/1/)

How can I get an ISO 8601 from moment.js?

How do I format a date as ISO 8601 in moment.js?

How can I insert into table with different input using /   ,with **date datatype**?

    insert into run(id,name,dob)values(&amp;id,&#39;&amp;name&#39;,[what should I write here?]);

I&#39;m using  oracle 10g.
 


How to insert date values into table

The [`DateTimeFormatter`][1] class documentation says about its formatting codes for the year:

&gt;   u       year                        year              2004; 04
&gt;
&gt;   y       year-of-era                 year              2004; 04
&gt;
&gt;…
&gt;
&gt;**Year:** The count of letters determines the minimum field width below which padding is used. If the count of letters is two, then a reduced two digit form is used. For printing, this outputs the rightmost two digits. For parsing, this will parse using the base value of 2000, resulting in a year within the range 2000 to 2099 inclusive. If the count of letters is less than four (but not two), then the sign is only output for negative years as per SignStyle.NORMAL. Otherwise, the sign is output if the pad width is exceeded, as per SignStyle.EXCEEDS_PAD.

No other mention of “era”.

So what is the difference between these two codes, `u` versus `y`, `year` versus `year-of-era`?

When should I use something like this pattern `uuuu-MM-dd` and when `yyyy-MM-dd` when working with dates in Java?

Seems that example code written by those in the know use `uuuu`, but why? 

Other formatting classes such as the legacy [`SimpleDateFormat`][2] have only `yyyy`, so I am confused why java.time brings this `uuuu` for “year of era”.


  [1]: https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/time/format/DateTimeFormatter.html
  [2]: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html

Content Type	Original Author	Original Content on Stackoverflow
Question	user1642513	View Question on Stackoverflow
Solution 1 - Python	BubbleGuppies	View Answer on Stackoverflow
Solution 2 - Python	Andy Hayden	View Answer on Stackoverflow
Solution 3 - Python	Benjamin Crouzier	View Answer on Stackoverflow

How to specify date format when using pandas.to_csv?

Python Problem Overview

Python Solutions

Solution 1 - Python

Solution 2 - Python

Solution 3 - Python

Reading JavaScript variables using Selenium WebDriver

Android proguard, keep inner class

Attributions