I have a gazillion CSV files and in column 2 is the x-data and column 3 is the y-data. Each CSV file is a different time stamp. The x-data is slightly different in each file, but the number of rows is constant. I'm happy to assume the x-data is in fact identical.
I am persuaded that Tableau is a good interface for me to do some visualization and happily installed tabpy and "voila", I can call python from Tableau... except...  to return an array I will need to return a string with comma separated values for each time stamp, and then one of those strings per x-axis and then.... Hmm, that doesnt sound right.
I tried telling Tableau just open them all and I'd join them later, but gave up after 30 mins of it crunching.
So what do you reckon? I am completely agnostic. Install an SQL server and create a database? Create a big CSV file that has a time-stamp for each column? Google? JSON?
Or maybe there is some clever way in Tableau to loop through the CSV files?
If you are using Windows, you can combine all the csv files into a single csv, then import that into Tableau. This of course assumes that all of your csv files have the same data structure.

Open the command prompt
Navigate to the directory where the csv files are (using the cd command)
Use the command copy *.csv combined-file.csv. The combined-file.csv can be whatever name you want.
Load thousands of CSV files into tableau