Parse from String Series to Timestamp (unit: ms)

100%

Parse from String Series to Timestamp (unit: ms)

✓ Published0🌍 Public

Last edited Apr 25, 2017

Created on Apr 25, 2017

This example converts string-formatted timestamps in a pandas DataFrame into millisecond-precision Unix timestamps. It shows how a time column can be transformed for downstream time-series analysis or plotting. The code uses `s.apply` with a lambda function that calls `datetime.datetime.strptime` to parse the "%Y-%m-%d %H:%M:%S" format, then `strftime('%s')` to extract seconds and multiplies by 1000 to obtain milliseconds. The source data is a DataFrame column assumed to contain such timestamp strings.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 74cb28602595c2a18d8c9de77ebabe78

This visualization shows a time-series dataset from `timedata.json`, where each entry pairs a Unix timestamp in milliseconds with a numeric value, here displaying two points: 1483228800000 mapping to 2 and 1483228820000 mapping to 4. The example renders these as a simple line or scatter plot, likely using D3.js with `d3.scaleTime` for the x-axis and `d3.scaleLinear` for the y-axis. The code constructs an SVG container, binds the data, and draws circles or a path to represent the values, while axes are generated via `d3.axisBottom` and `d3.axisLeft`. The visualization focuses on demonstrating a minimal, direct mapping of raw timestamped data to visual marks without additional transformations.

VVioletVivirand

49% match

Loading thumbnail…

Gist 25342708e9edeb5099b496447772d743

The visualization shows a technique for analyzing log files by measuring time gaps between consecutive timestamped entries. It uses Python’s `datetime.strptime` to parse timestamps from `"YYYY-MM-DD HH:MM:SS.mmm"` formats and calculates differences in milliseconds, flagging intervals exceeding 10 ms. The code filters log lines by keyword using standard file I/O operations and prints matching entries, or reads all lines from a file to identify timing anomalies. This example demonstrates text-based log inspection rather than graphical rendering, relying on Python console output for insights.

JJastor11

48% match

Loading thumbnail…

Gist 575a4d1a506d4f39d35f

This example presents a collection of Python code snippets for data manipulation with the pandas library, focusing on common DataFrame operations. It demonstrates techniques for filtering rows based on column values, handling missing data, renaming columns, and performing data type conversions. The snippets also cover more advanced operations like pivot tables, merging delimited values, and using `pd.melt` for reshaping data. The code includes functions like `df.column_name.unique()`, `pd.pivot_table`, and `df.assign` to illustrate practical workflows for cleaning and transforming tabular data.

SSav10

47% match

Loading thumbnail…

Milliseconds since Unix Epoch

This example converts the current date and time into a single integer representing the number of milliseconds elapsed since the Unix epoch (January 1, 1970). It uses the XQuery function `local:milliseconds-since-epoch`, which calculates the duration between the current timestamp and the epoch, then extracts and sums the day, hour, minute, and second components scaled to milliseconds. The code relies on XQuery’s built-in date and duration types and functions, including `fn:current-dateTime()`, `xs:dateTime()`, `xs:duration()`, and `fn:days-from-duration()`. The result is returned as an `xs:integer`, demonstrating a fundamental time-conversion utility.

CCliffordAnderson

44% match

Loading thumbnail…

Gist d003ece0b6ca171be8e095e0bc90af7e

This notebook example demonstrates how to programmatically scrape, parse, and structure a corpus of New York Times articles into a pandas DataFrame. The code loads a pre-saved pickle file of 50 article links, iterates through each URL using the `newspaper` library's `Article` class, and extracts the article’s text, title, publication date, keywords, and summary. It then stores the results in a list of dictionaries and converts that list into a structured DataFrame. The script includes error handling for unparseable articles, inserting `NaN` values, and prints the total execution time, which took roughly 38.5 seconds for this run. The displayed table shows the resulting columns: date, keywords, link, summary, text, and title.

GGeorgeMcIntire

44% match

Loading thumbnail…

fresh block

This example demonstrates how to parse a date string containing a timezone offset and extract its local time components using D3’s time parsing utilities. It converts an ISO-like timestamp with a UTC offset into a JavaScript Date object via `d3.timeParse`, then reassembles the hours and minutes into a new string with a different format. The code uses `d3.timeParse` twice, first with a format that includes the offset and second without it, but does not render any visualization.

MMathReynaud

44% match

Loading thumbnail…

Subsecond Ticks

A line chart plots value against time with subsecond precision, using a time scale for the x-axis and a linear scale for the y-axis. The bottom axis displays ticks at fractional seconds, demonstrating correct behavior for millisecond-level time domains. Built with D3 v3, the example uses `d3.svg.axis` for tick generation, `d3.svg.line` for the path, and `d3.time.scale` for mapping dates. Data is loaded from a tab-separated file via `d3.tsv`, with timestamps converted from Unix seconds into JavaScript `Date` objects.

Mmbostock

43% match

Loading thumbnail…

DateTime difference between 2 timestamps. Granularity from centuries to nanos.

This example shows the elapsed time between September 11, 2001, and the current moment, broken down into units from centuries down to nanoseconds. Two approaches are compared: the first uses Java’s `ChronoUnit` enumeration with a tail-recursive function to compute differences across twelve granularities, while the second uses `TimeUnit` conversion and `ZoneOffset` to produce a day-to-second breakdown. The Scala code builds a human-readable string, adjusting unit labels for singular values, and prints both outputs from the `Stopwatch` object.

PP7h

43% match