Python Forum
Pandas read csv file in 'date/time' chunks
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas read csv file in 'date/time' chunks
#4
(Feb-12-2023, 06:42 PM)jefsummers Wrote: I'd give a thought to a Pandas alternative. There are several, and when you run into a pandas limitation (or speed issue) take a look.

Polars - listen to the recent Talk Python To Me Podcast for some details (episode 402)

Vaex - supports up to a billion rows

Dask

PySpark - Python wrapper for Spark which is written in scala, supports large datasets and distributed computing.

Thanks for the feedback.

I'd already started coding up putting the data into a database and reading the data from there, but I will definitely look into your suggestions to see if they can do what I want in the future.
Reply


Messages In This Thread
RE: Pandas read csv file in 'date/time' chunks - by MorganSamage - Feb-13-2023, 11:21 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [Numpy] Load date/time from .txt to 'datetime64' type. water 4 795 Mar-01-2024, 11:16 PM
Last Post: Gribouillis
  Parsing and summing time deltas (duration) onto bar + pie charts using pandas - - DRY Drone4four 2 669 Feb-10-2024, 06:04 PM
Last Post: Drone4four
Smile How to further boost the data read write speed using pandas tjk9501 1 1,311 Nov-14-2022, 01:46 PM
Last Post: jefsummers
  How to import an xml file to Pandas sjhazard 0 2,406 Jun-08-2021, 08:19 PM
Last Post: sjhazard
  Does a pandas have a date without a time? AlekseyPython 6 5,037 Feb-10-2021, 09:24 AM
Last Post: Naheed
  Pandas - compute means per category and time rama27 7 3,602 Nov-13-2020, 08:55 AM
Last Post: PsyPy
Lightbulb Allocating maximum memory to chunks Robotguy 1 1,443 Oct-13-2020, 02:59 AM
Last Post: Larz60+
  Accessing details of chunks in HDF5 file Robotguy 0 1,603 Aug-29-2020, 06:51 AM
Last Post: Robotguy
  Can't read text file with pandas zinho 6 12,250 May-24-2020, 06:13 AM
Last Post: azajali43
  Read json array data by pandas vipinct 0 1,980 Apr-13-2020, 02:24 PM
Last Post: vipinct

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020