【Pandas-Cookbook】08：时间戳处理

解析Unix时间戳

最新推荐文章于 2023-09-18 10:21:20 发布

原创最新推荐文章于 2023-09-18 10:21:20 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#pandas

Python 同时被 3 个专栏收录

61 篇文章

订阅专栏

Pandas数据分析

12 篇文章

订阅专栏

基于python的数据分析库Pandas

10 篇文章

订阅专栏

本文介绍如何使用Python的pandas库解析Unix时间戳，并展示了从CSV文件读取数据、转换时间戳格式、筛选特定日期之后的数据及按列排序等操作。

# -*-coding:utf-8-*-

#  by kevinelstri
#  2017.2.17

# ---------------------
# Chapter 8 - How to deal with timestamps.ipynb
# ---------------------

import pandas as pd

'''
    8.1 Parsing Unix timestamps
'''
popcon = pd.read_csv('../data/popularity-contest', sep=' ')
# print popcon.head()
popcon.columns = ['atime', 'ctime', 'package-name', 'mru-program', 'tag']
# print popcon[:5]
print popcon['atime'].dtype

popcon['atime'] = popcon['atime'].astype(int)
# print popcon['atime'][:5]
# popcon['ctime'] = popcon['ctime'].astype(int)
popcon['atime'] = pd.to_datetime(popcon['atime'])
# popcon['ctime'] = pd.to_datetime(popcon['ctime'], unit='s')
# print popcon['atime'][:5]

popcon = popcon[popcon['atime'] > '1970-01-01']
nonlibraries = popcon[~popcon['package-name'].str.contains('lib')]
nonlibraries.sort('ctime', ascending=False)[:10]