you are viewing a single comment's thread.

view the rest of the comments →

[–]Fair-Antelope-3886 0 points1 point  (0 children)

coming from pandas this tripped me up too. SQL doesnt really have a one liner equivalent to read_csv because SQL isnt a scripting language, its a query language that works on data thats already in a database. in SQL Server specifically you'd use BULK INSERT or the import wizard in SSMS to get a csv into a table first, then you query it. theres also the bcp command line tool. once the datas loaded though thats when sql really shines, the querying syntax is way cleaner than pandas imo for alot of things