Тёмный

Import CSV files into PostgreSQL | pgAdmin | Data Analyst Skill Tutorial #3 

Alex Sington
Подписаться 1,7 тыс.
Просмотров 19 тыс.
50% 1

Kaggle data set: www.kaggle.com/datasets/evang...
This skill tutorial covers how to create a table in PostreSQL 15 (pgAdmin 4) and import data from a CSV file.
Contact me:
alex.sington@gmail.com
/ alex-sington-b7751a181
Intro: 0:00
Creating a table: 0:15
Importing the CSV file: 5:02

Опубликовано:

 

23 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 19   
@SilviaGarcia-bv7cz
@SilviaGarcia-bv7cz 22 дня назад
Thank you very very much! from Argentina
@abhishekbaliyan8243
@abhishekbaliyan8243 10 месяцев назад
i watched and read several articles on how to add a .csv file but wasn't able to add it finally i figured it out from your video that i should have checked the header .. thanks mate
@jesuslogistico7067
@jesuslogistico7067 Год назад
I'm from Brazil, thanks for the help
@soumyajeetmitra6958
@soumyajeetmitra6958 4 месяца назад
wow great fun and brief learning
@kumaraswamy3452
@kumaraswamy3452 5 месяцев назад
thanks mate , helped me a lot
@daveys
@daveys 3 месяца назад
Good tutorial, thanks for that
@silvestrecamposano6317
@silvestrecamposano6317 Год назад
Sir, ... Thank you very much for the technique... I can apply it in my office job....
@JeffreyJohnsonC
@JeffreyJohnsonC 8 месяцев назад
Good tutorial.
@wolverinelogan8980
@wolverinelogan8980 9 месяцев назад
May I ask a question. What if I am going to import a csv file that has 300 or 500 columns given by the company I am working with. Do I necessarily do that? It would take some time for them to get the insights they wanted. What if there are 10 tables with 400 columns each. Do I really need to do that to provide the insights that the company is expecting?
@kadakolo5642
@kadakolo5642 Год назад
Is it really necessary to create each table manually? I have a mysql database with 120 tables, tens of thousands rows of data - some tables have like 20-100 columns - this will take a week to just create them ?
@rishabhchakraborty1819
@rishabhchakraborty1819 Год назад
Thanks
@RealAndyOriginal
@RealAndyOriginal Год назад
What if you are trying to import a csv file that has 300 columns? You have to manually type in all the column names and column types? There has to be an easier way.
@jayeshsuryawanshi2155
@jayeshsuryawanshi2155 Год назад
exactly
@JeffreyJohnsonC
@JeffreyJohnsonC 8 месяцев назад
You could do it programmatically with a script to create the fields.
@graceamah996
@graceamah996 2 месяца назад
​@@JeffreyJohnsonChow please
@Theoadams95
@Theoadams95 Год назад
I tried doing something like this and it failed.
@OluchiMae
@OluchiMae 4 месяца назад
Hi I tried but it keeps failing every time Process started is successful but the other one isn’t
@abdullahoguntade1649
@abdullahoguntade1649 4 месяца назад
I also had similar problems but if you check the error you should see what went wrong. In my own case i made a mistake in the datatype check your csv file properly to ensure that each column has the same dtattype in all rows and it doesnt have an error in the csv file
Далее
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 182 тыс.
БАССЕЙНЫ ПО ЦВЕТАМ ЧЕЛЛЕНДЖ !
38:20
Import CSV files using pgAdmin
2:14
Просмотров 2,9 тыс.
How I use SQL as a Data Analyst
15:30
Просмотров 812 тыс.
Import CSV file into PostgreSQL with PgAdmin
5:26
Просмотров 64 тыс.
Import XSLX/CSV File To PostgreSQL database
11:29
Просмотров 84 тыс.