ValueError: time data '1/2/2012 12:32:11' does not match
format '%Y/%m/%d %H:%M:%S'
そのため、ディクショナリの
data
リスト用に既知のフォーマットの日付フィールドを
datetime
に変換するには、次のように実行します。
for d in data:
try:
d['date'] = datetime.strptime(d['date'],\
'%Y/%m/%d %H:%M:%S')
except ValueError:
print('Oops! - invalid date for ' + repr(d))
2
つの最も人気のデータファイルフォーマットに対応できました。さらに大物に取り組みましょ
う。次は
SQL
や
NoSQL
データベースに対してデータを読み書きしてみましょう。
3.6
SQL
SQL
データベースとのやり取りには、
SQLAlchemy
が最も一般的です。私見では
SQLAlchemy
は最も優れた
Python
ライブラリです。速度と効率が重要であれば生の
SQL
命令を使いますが、
強力なオブジェクトリレーショナルマッピング(
ORM
:
Object-Relational Mapping
)も提供し、
高水準の
Python
らしい(
Pythonic
)
API
で
SQL
テーブルを操作でき、基本的に
SQL
テーブルを
Python
クラスとして扱えます。
SQL
を使ってデータを読み書きし、ユーザがそのデータを
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.