The simplest is to do a PivotChart.
Select your array of dates (with a header) and create a new Pivot Chart (Insert / PivotChart / Ok)
Then on the field list window, drag and drop the date column in the Axis list first and then in the value list first.

**Step 1:**

![Step1][1]

**Step 2:**

![Step2][2]


  [1]: http://i.stack.imgur.com/mezpW.png
  [2]: http://i.stack.imgur.com/Ox3wZ.png

If you have Excel 2010 you can copy your data into another column, than select it and choose Data -&gt; Remove Duplicates. You can then write `=COUNTIF($A$1:$A$100,B1)` next to it and copy the formula down. This assumes you have your values in range `A1:A100` and the de-duplicated values are in column B.

Is it possible to create pinterest like layout on Android using `GridView`? I want to create image gallery using `GridView` but I am not sure if it is good solution. I do not want create three `LinearLayouts` (I think that this solution is not good: https://stackoverflow.com/questions/9897808/pinterest-style-listview-or-gridview-in-android) 

Any ideas ;)?

![enter image description here][1]


  [1]: http://i.stack.imgur.com/8nvG8.jpg

Android heterogeneous gridview like pinterest?

When including the factory_bot_rails gem in your dev and test blocks in Gemfile, rails will generate factories automatically when your models are generated. 

Is there a way to generate factories after your models have been generated?

---

Note: FactoryBot was previously named FactoryGirl

Can FactoryBot generate factories after your models have been created?

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number of times the date occurs and the X axis being the date itself)?

Sample list:

    19/05/2012
    19/05/2012
    19/05/2012
    17/05/2012
    17/05/2012
    16/05/2012
    16/05/2012
    16/05/2012
    16/05/2012
    15/05/2012
    15/05/2012
    15/05/2012
    15/05/2012
    12/05/2012
    12/05/2012
    12/05/2012
    7/05/2012

I clicked every menu option over the past few years and never did I find anything specific to this. Would this be a case for using PivotTables somehow?

Count number of times a date occurs and make a graph out of it

I have a list of dates, each date in it can occur more than once. I want to count the number of times each date occurs (histogram) and display it in a graph (with the Y axis being the number of times the date occurs and the X axis being the date itself)?
Sample list:
<pre><code class="hljs">19/05/2012
19/05/2012
19/05/2012
17/05/2012
17/05/2012
16/05/2012
16/05/2012
16/05/2012
16/05/2012
15/05/2012
15/05/2012
15/05/2012
15/05/2012
12/05/2012
12/05/2012
12/05/2012
7/05/2012
</code></pre>
I clicked every menu option over the past few years and never did I find anything specific to this. Would this be a case for using PivotTables somehow?

This seems like a simple Pivot Table to learn with.  I would like to do a count of unique values for a particular value I&#39;m grouping on.

For instance, I have this:

    ABC   123
    ABC   123
    ABC   123
    DEF   456
    DEF   567
    DEF   456
    DEF   456

What I want is a pivot table that shows me this:

    ABC   1
    DEF   2

The simple pivot table that I create just gives me this (a count of how many rows):

    ABC   3
    DEF   4  

But I want the number of unique values instead.

What I&#39;m really trying to do is find out which values in the first column don&#39;t have the same value in the second column for all rows.  In other words, &quot;ABC&quot; is &quot;good&quot;, &quot;DEF&quot; is &quot;bad&quot;

I&#39;m sure there is an easier way to do it but thought I&#39;d give pivot table a try...

Simple Pivot Table to Count Unique Values

I&#39;ve found this method for finding the last data containing row in a sheet:

    ws.Range(&quot;A65536&quot;).End(xlUp).row

Is there a similar method for finding the last data containing column in a sheet?

How do I find the last column with data?

I am using a While...Wend loop of VBA.

    Dim count as Integer
    
    While True
        count=count+1

        If count = 10 Then
            &#39;&#39;What should be the statement to break the While...Wend loop? 
            &#39;&#39;Break or Exit While not working
        EndIf
    Wend

I don&#39;t want to use condition like `While count&lt;=10...Wend

Break out of a While...Wend loop

I&#39;m currently using pandas to read an Excel file and present its sheet names to the user, so he can select which sheet he would like to use. The problem is that the files are really big (70 columns x 65k rows), taking up to 14s to load on a notebook (the same data in a CSV file is taking 3s).

My code in panda goes like this:

    xls = pandas.ExcelFile(path)
    sheets = xls.sheet_names

I tried xlrd before, but obtained similar results. This was my code with xlrd:

    xls = xlrd.open_workbook(path)
    sheets = xls.sheet_names

So, can anybody suggest a faster way to retrieve the sheet names from an Excel file than reading the whole file?

How to obtain sheet names from XLS files without loading the whole file?

I&#39;m generating a CSV file (delimited by commas rather than tabs). My users will most likely open the CSV file in Excel by double clicking it. My data may contain commas and speech marks, so I&#39;m escaping those as follows.

    Reference, Title, Description
    1, &quot;My little title&quot;, &quot;My description, which may contain &quot;&quot;speech marks&quot;&quot; and commas.&quot;
    2, &quot;My other little title&quot;, &quot;My other description, which may also contain &quot;&quot;speech marks&quot;&quot; and commas.&quot;

As far as I know that&#39;s always been the way to do it. Here&#39;s my boggle: when I open this file in Excel 2010 my escaping is not respected. Speech marks appear on the sheet, and the comma causes new columns.



How should I escape commas and speech marks in CSV files so they work in Excel?

Note, I do NOT want millis from epoch. I want the number of milliseconds currently on the clock.

So for example, I have this bit of code.

    Date date2 = new Date(); 
    Long time2 = (long) (((((date2.getHours() * 60) + date2.getMinutes())* 60 ) + date2.getSeconds()) * 1000);
		
Is there a way to get milliseconds with date?
Is there another way to do this?

**Note:** `System.currentTimeMillis()` gives me millis from epoch which is not what I&#39;m looking for.

How can I get the count of milliseconds since midnight for the current?

I need to select data from MySQL database between the 1st day of the current month and current day.

    select*from table_name 
    where date between &quot;1st day of current month&quot; and &quot;current day&quot;

Can someone provide working example of this query?

How do I select between the 1st day of the current month and current day in MySQL?

How do I convert &#39;timeStamp&#39; to `date` after I get the count in java?

My current code is as follows:

    public class GetCurrentDateTime {
    
        public int data() {
            int count = 0;
            java.sql.Timestamp timeStamp = new Timestamp(System.currentTimeMillis());
            java.sql.Date date = new java.sql.Date(timeStamp.getTime()); 
			System.out.println(date);
            //count++;
    
            try {
                Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
                Connection con = DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/pro&quot;, &quot;root&quot;, &quot;&quot;);
    
                PreparedStatement statement = con.prepareStatement(&quot;select * from orders where status=&#39;Q&#39; AND date=CURDATE()&quot;);
                ResultSet result = statement.executeQuery();
                while (result.next()) {
                    // Do something with the row returned.
                    count++; //if the first col is a count.
                }
            } catch (Exception exc) {
                System.out.println(exc.getMessage());
            }

            return count;
        }
    }

This is my database:
![enter image description here][1]

  [1]: http://i.stack.imgur.com/4wXsC.png

Here the output I got was 2012-08-07 0, but the equivalent query returns 3. Why do I get 0?

How to convert TimeStamp to Date in Java?

I want to do something like:

    Date date = new Date(); // current date
    date = date - 300; // substract 300 days from current date and I want to use this &quot;date&quot;

How to do it? 

How to subtract X day from a Date object in Java?

How can I convert normal date `2012.08.10` to unix timestamp in javascript?

Fiddle: http://jsfiddle.net/J2pWj/
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
I&#39;ve seen many posts here that convert it in PHP, Ruby, etc... But I need to do this inside JS.

Convert normal date to unix timestamp

So i have a page already which draws a force directed graph, like the one shown [here][1].

And that works fine. I&#39;m using the JS from [here][2], with a few tweaks to spread out the nodes slightly nicer.

These are more or less the only differences:

    d3.json(&quot;force.json&quot;, function(json) {
      var force = d3.layout.force()
          .gravity(0.1)
          .charge(-2000)
          .linkDistance(1)
          .linkStrength(0.1)
          .nodes(json.nodes)
          .links(json.links)
          .size([w, h])
          .start();

Where reducing the link strength seems to make the links more like springs, so it becomes similar to the [Fruchterman &amp; Reingold][3] technique often used. This works reasonably well, but only for fairly small graphs. With larger graphs the number of crossings just goes up - as one would expect, but the solution it lands on is normally far from optimal. I&#39;m not looking for a method to get the optimal solution, I know that&#39;s very difficult. I would just like it to have some crude addition that tries to force the lines apart as well as the nodes.

**Is there a way to add a repulsion between in links, as well as between the nodes?** I&#39;m not familiar with the way D3 force works, and i can&#39;t seem to find anything that says this is possible...


  [1]: http://networkx.lanl.gov/
  [2]: http://mbostock.github.com/d3/ex/force.html
  [3]: http://en.wikipedia.org/wiki/Force-based_algorithms_%28graph_drawing%29

D3.js force directed graph, reduce edge crossings by making edges repel each other

I need a working algorithm for finding all simple cycles in an undirected graph. I know the cost can be exponential and the problem is NP-complete, but I am going to use it in a small graph (up to 20-30 vertices) and the cycles are small in number.

After a long research (mainly here) I still don&#39;t have a working approach. Here is a summary of my search:

https://stackoverflow.com/questions/5068086/finding-all-cycles-in-an-undirected-graph

https://stackoverflow.com/questions/526331/cycles-in-an-undirected-graph -&gt; detects only whether there is a cycle or not

https://stackoverflow.com/questions/9804127/finding-polygons-within-an-undirected-graph -&gt; very nice description, but no solution

https://stackoverflow.com/questions/546655/finding-all-cycles-in-graph/549402#549402 -&gt; finds cycles only in directed graphs

https://stackoverflow.com/questions/9626249/detect-cycles-in-undirected-graph-using-boost-graph-library

The only answer I found, which approaches my problem, is this one:

https://stackoverflow.com/questions/2839908/find-all-cycles-in-graph-redux

It seems that finding a basic set of cycles and XOR-ing them could do the trick. Finding a basic set of cycles is easy, but I don&#39;t understand how to combine them in order to obtain all cycles in the graph...

Finding all cycles in undirected graphs

I read it is ideal to represent sparse graphs by adjacency lists and dense graphs by an adjacency matrix. But I would like to understand the main difference between sparse and dense graphs. 

What is the distinction between sparse and dense graphs?

I was wondering what&#39;s the difference between _uniform-cost search_ and _Dijkstra&#39;s algorithm_. They seem to be the same algorithm.

What&#39;s the difference between uniform-cost search and Dijkstra&#39;s algorithm?

Can anyone recommend a Python library that can do **interactive** graph visualization?

I specifically want something like [d3.js][1] but for `python` and ideally it would be 3D as well. 

I have looked at:

 - [NetworkX][2] - it only does `Matplotlib` plots and those seem to be 2D. I didn&#39;t see any sort of interactiveness, like one that `d3.js` gives, such as pulling nodes around.
 - [graph-tool][3] - it does only 2D plots and has very slow *interactive* graphs.


  [1]: https://d3js.org/
  [2]: https://networkx.readthedocs.io/en/stable/
  [3]: https://graph-tool.skewed.de/

Python equivalent of D3.js

I have a column of values that often appear as duplicates. I need to create a new column, of unique values based on the first column, as follows:

    Column A   Column B  
    a          a
    a          b
    b          c
    c
    c

This Column B will actually need to appear on a different sheet, within the same workbook, so I assume it will need to work with the `sheet2!A1` style format.

I have not had any luck with the Data/Filter menu options as this only seems to work on command. I need column B to update automatically whenever a new value is entered into column A. 

Ignore Duplicates and Create New List of Unique Values in Excel

In this section of code, Excel ALWAYS prompts: &quot;File already exists, do you want to overwrite?&quot;

    Application.DisplayAlerts = False
    Set xls = CreateObject(&quot;Excel.Application&quot;)
    Set wb = xls.Workbooks.Add
    fullFilePath = importFolderPath &amp; &quot;\&quot; &amp; &quot;A.xlsx&quot;
    
    wb.SaveAs fullFilePath, AccessMode:=xlExclusive, ConflictResolution:=True   
    
    wb.Close(True)

Why does `db.SaveAs` always prompt me to overwrite existing file if I have `DisplayAlerts = False`?

How to use workbook.saveas with automatic Overwrite

Using Microsoft Excel 2010, I noticed two kind of controls that can be inserted into a document: *Form Controls* and *ActiveX Controls*. 

![enter image description here][1]

What is the difference between them?


  [1]: http://i.stack.imgur.com/02BSl.png

What is the difference between &quot;Form Controls&quot; and &quot;ActiveX Control&quot; in Excel 2010?

I would like to write an IF statement, where the cell is left blank if the condition is FALSE.
Note that, if the following formula is entered in C1 (**for which the condition is false**) for example:

     =IF(A1=1,B1,&quot;&quot;)

and if C1 is tested for being blank or not using `=ISBLANK(C1)`, this would return `FALSE`, even if C1 seems to be blank. This means that the `=IF(A1=1,B1,&quot;&quot;)` formula does not technically leave the cells blank if the condition is not met.

Any thoughts as to a way of achieving that? Thanks,

IF statement: how to leave cell blank if condition is false (&quot;&quot; does not work)

Mysql: Select rows from a table that are not in another

So I&#39;m trying to make this program that will ask the user for input and store the values in an array / list.  
Then when a blank line is entered it will tell the user how many of those values are unique.  
I&#39;m building this for real life reasons and not as a problem set.

    enter: happy
    enter: rofl
    enter: happy
    enter: mpg8
    enter: Cpp
    enter: Cpp
    enter:
    There are 4 unique words!

My code is as follows:

    # ask for input
    ipta = raw_input(&quot;Word: &quot;)

    # create list 
    uniquewords = [] 
    counter = 0
    uniquewords.append(ipta)

    a = 0   # loop thingy
    # while loop to ask for input and append in list
    while ipta: 
      ipta = raw_input(&quot;Word: &quot;)
      new_words.append(input1)
      counter = counter + 1

    for p in uniquewords:


..and that&#39;s about all I&#39;ve gotten so far.  
I&#39;m not sure how to count the unique number of words in a list?  
If someone can post the solution so I can learn from it, or at least show me how it would be great, thanks!
    
    

How do I count occurrence of unique values inside a list

Given a `[&#39;0&#39;,&#39;1&#39;,&#39;1&#39;,&#39;2&#39;,&#39;3&#39;,&#39;3&#39;,&#39;3&#39;]` array, the result should be `[&#39;0&#39;,&#39;1&#39;,&#39;2&#39;,&#39;3&#39;]`.

How to get an array of unique values from an array containing duplicates in JavaScript?

I&#39;ve got almost the same question as [here][1].

I have an array which contains `aa ab aa ac aa ad`, etc.
Now I want to select all unique elements from this array.
Thought, this would be simple with `sort | uniq` or with `sort -u` as they mentioned in that other question, but nothing changed in the array...
The code is:

    echo `echo &quot;${ids[@]}&quot; | sort | uniq`

What am I doing wrong?

  [1]: https://stackoverflow.com/questions/618378/select-unique-or-distinct-values-from-a-list-in-unix-shell-script

How can I get unique values from an array in Bash?

How can I find the unique lines and remove all duplicates from a file?
My input file is 

    1
    1
    2
    3
    5
    5
    7
    7

I would like the result to be:

    2
    3

`sort file | uniq` will not do the job. Will show all values 1 time





Content Type	Original Author	Original Content on Stackoverflow
Question	SystemX17	View Question on Stackoverflow
Solution 1 - Excel	edeboursetty	View Answer on Stackoverflow
Solution 2 - Excel	martin	View Answer on Stackoverflow

Count number of times a date occurs and make a graph out of it

Excel Problem Overview

Excel Solutions

Solution 1 - Excel

Solution 2 - Excel

Can FactoryBot generate factories after your models have been created?

Android heterogeneous gridview like pinterest?

Attributions