date time format %Y-%m-%d %H:%M:%S to create line chart

[arvind111]

Hi Pyxley Team ,

first of all congratulation for the Wonderfull framework . I have one query here if i would like to create a line chart given in example metricsgraphics with date - time(x- axis) so what should be format of Date Column in the csv file for date - time(x axis) .
dateparse = lambda x: pd.datetime.strptime(x, '%Y-%m-%d %H:%M:%S')
df = pd.read_csv("fitbit_data.csv", parse_dates=['Date'], date_parser=dateparse)
sf = df.set_index("Date").stack().reset_index()
i have already tried but line charts failed with Date as %Y-% m-%d %H:%M:%S. line charts only works well with date format as %Y-% m-%d .

[nperony]

Hi, another Pyxley user here. At Tamedia Digital (Zurich), the data science team is planning to use Pyxley for quick dashboard implementation. We'd love to see datetimes supported for line charts. Thanks!

[sanjeevbhalla]

Another user who is using Pyxley and ran into this same issue. One should be allowed to specify the date format of the data.

[nmkridler]

I think the problem is that I'm casting a string to a Date. You should be able to format however you like, it just needs to be a string when it's transmitted to the javascript. I can probably force that in the default request function.

[sanjeevbhalla]

No. I tried string and it did not work. If I recall right the problem is
that the MG date formatting function that is called from d3 expects a
format and without a format passed it assumes a default of Y M and D. That
is my recollection when I tried to understand whats going on.

Thanks

On Thu, Jan 7, 2016 at 8:23 AM, Nick Kridler [email protected]
wrote:

I think the problem is that I'm casting a string to a Date. You should be
able to format however you like, it just needs to be a string when it's
transmitted to the javascript. I can probably force that in the default
request function.

—
Reply to this email directly or view it on GitHub
#17 (comment).

[nmkridler]

Here's the javascript code that does the conversion.

    _update: function(params) {
        d3.json(this.props.options.url.concat("?",$.param(params)),
            function(error, data){
                var options = this.props.options.params;
                if(data.date){
                    for(var i=0; i < data.result.length; i++){
                        data.result[i] = MG.convert.date(data.result[i], "x");
                    }
                }
                options.data = data.result;
                MG.data_graphic(options);
            }.bind(this));
    },

https://github.com/stitchfix/pyxleyJS/blob/master/src/metricsgraphics.js

I'll have to look in to it and try it with different date formatting.

[sanjeevbhalla]

Right. On this line data.result[i] = MG.convert.date(data.result[i], "x"); is
called to convert Date. But because no format is passed it uses default
format of %Y-%m-%d

https://github.com/mozilla/metrics-graphics/wiki/Convenience-Functions
Converts a data object's values from strings to javascript Date objects
that can then be plotted. The function parses %Y-%m-%d-styled timestamps by
default. An optional third argument allows one to specify an alternative
style, per the formats defined here:
How do I as user of Pyxley override this behavior? (Sorry if I am missing
something obvious - I am not a Javascript expert).

Thanks for your help.

On Thu, Jan 7, 2016 at 8:47 AM, Nick Kridler [email protected]
wrote:

Here's the javascript code that does the conversion.

https://github.com/stitchfix/pyxleyJS/blob/master/src/metricsgraphics.js

—
Reply to this email directly or view it on GitHub
#17 (comment).

[markosole]

This worked for me:

for(var i = 0; i < data.length; i++) {
                    data[i] = MG.convert.date(data[i], 'date', '%Y-%m-%dT%H:%M:%SZ'); 
 }

My date in database looks like this: 2018-04-28T13:24:55Z