Import CSV file to SQL Server Using Python | SQL | Python

Import CSV file to SQL Server Using Python | SQL | Python

In this video, I will teach you how to insert a CSV file to an SQL server using python

Large Language Model (LLM) - LangChain

Large Language Model (LLM) - LlamaIndex

Machine Learning Model Deployment

Spark with Python (PySpark)

Data Preprocessing (scikit-learn)

Social Media Links

#llm #ai #genai #generativeai #statswire #pyspark #python #pythonprogramming #pythontutorial #machinelearning #datascience
#Python #SQL #Insert

[tomoekul]

Hi did you change your code at around 7:07, and if so what did you change it to? I' struggling to get this part working. Thanks

[monikasingh]

@StatsWire Hi. Can you please tell me from where you are reading fetching csv file? I am doing one programme in which I will upload excel files and then excel data needs to be add in azure sql in which table is already created. Can you please throw some light how i can do that? or any help would be grated.

[SundarKannan_Tenkasi]

Nice Explanation, Easy to Understand the code

[pratikgazelli]

Hello. I wan't to bulk load a huge csv dataset into sql workbench which has several columns. What would be a better way?

[thuyvuong]

When I run this the pip command to install pyodbc, it doesn't work. So I checked the version of python I had and it says I don't have python installed. Is this because I didn't install a separate version from the juptyer notebooks? Do I have to install another version? The Python version in juptyer notebooks I have is 3.9.7. I want to follow the tutorial and try it out.

[aravinddx]

Hi,
We are using different machines to insert data on tables using python..
As per ms sql I can't insert more than 999 rows in single inert query.
Also bulk insert(csv) works on server only..
It that any method to overcome this???

[islamicteachingslectures]

Hi, I got an error while executing the cursor query "InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')". Pls help me out, thanks

[deservads]

hi, nice video!

i got an error: ProgrammingError: ('Invalid parameter type. param-index=36 param-type=dict', 'HY105') do you know how to solve it?

[MrMLBson]

Is there any way to use python to write a csv directly to the database without the need of a dataframe?

[chitrajayapalan]

after typing pip install pyodbc in command prompt, i am getting a msg as 'pip' is not recognized as an internal or external command,
operable program or batch file. Plz help me in this

[hoosier-daddy]

Will this method work with other SQL workbenches? I’m using a Mac so not using SSMS.

[ronito]

When I try to insert into my table I get "NameError: name 'cursor' is not defined". I have cursor defined on cell 3 as such "cursor = conn.cursor()"...what am I missing?

[nikitapore]

i am getting error as ora-01036 illiegal variable name or number while inserting into table. my table is already present in database having all column types as nvarchar. dataframe column types are also string. please help.

[Kikeusb]

Thank You!!! The real MVP!!!, I was trying for more than 5 hours to do this in postgres. And it worked just needed to change ? for %s :)

[abelalejandrowolfgangyepez]

Hi, I'm keep getting this error "ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()." what it can be?

[sharamuthu]

HI sir, if we have 100+ columns how can we type all those, other than import option is there anyother thing?

[kennethwaynescott]

I keep getting this error on the last row of the INSERT statement, not matter what that last row is
Parameter 5 (""): The supplied value is not a valid instance of data type float

[cfsmkpy]

Hi Sir,
Getting error while inserting values into table in ' for loop ' as " 'Pandas' object has no attribute __(column_name)__ "

[ponvigneshshanmugam]

Hi, i got an error like "AttributeError: 'builtin_function_or_method' object has no attribute 'execute'

[VishGaitonde-kmoo]

how do we do this for 300+ CSVs with header row each ?