Pandas has some workarounds to work with datasets larger than your RAM unless you have a PC with 256Gb of RAM PC. (If you work with CFD you probably saw one of this kind). read more
While tools like Spark can handle large data sets (100 gigabytes to multiple terabytes), taking full advantage of their capabilities usually requires more expensive hardware. And unlike pandas, they lack rich feature sets for high quality data cleaning, exploration, and analysis. read more