Thanks for this. For some reason, I was always a bit afraid of these type of documents. You helped to really demystify them with this video. Kind thanks!
CSV format is very useful. Also useful is separating the data in the columns on each line with the tab character. Numbers and most spreadsheets handle this with no problems.
Nobody makes such clear videos full of useful information (even though you think you know everything about a certain topic already). Thanks Gary. It's always worth watching.
It is very convenient to have this simple CSV format that is not tied to a particular spreadsheet app for storing data. Some programming languages, such as Python, have some functionality, in the form of additional packages, that enable you to read CSV files, analyze them, and generate plots from them. For example, if the first column is Date and the second column is High Temperature, you can create a plot that shows high temperature as a function of date.
Thank you! I did not know about the plaint text mode in TextEdit. I use a backslash (\) to delimit, and I find LibreOffice helpful when opening a CSV file because it prompts me up front to specify how the fields are separated (fixed length or what delimiters).
I try to import huge data from some app, the excel file is too small for it as data has 65 mln rows, so I save it as txt file, but when I open it there is some html tags and no data, is it possible to resolve this problem, Please?
Probably. You'd have to work at it. Examine the file, clean it up using various techniques, etc. What do you do depends on what is in the file. It will take skills and hard work.
thanks for explaining about the quotes and commas for values - do you know anything about syntax errors from csv into consumer ui like mailchimp? couldn't import from csv because of syntax errors
In windows 10, I often make a folder full of movies, or other MP4 files. I do not create a CSV file, but when I list the files in the folder, there is a good CSV file among all these MP4s, listing all of the MP4s. I’m not sure if Windows creates that, or if the downloading software I use creates it. Has anyone else experienced this automatic appearance of a CVS file?
The best way is usually copy and paste. You can sometimes do it right into Numbers. If that doesn't work paste it into a text document and clean it up there first.
I have a CSV file and instead of a percentage I am just trying to increase the overall price of every item by one pound only but struggling to get it to work, I used to be able to do this years ago but just cannot recall how I did it, any help would be massively welcome.
It seems rare to find in references, directions on how to represent an EMPTY field within a record. If anyone needs to know, the way to do that is by using 2 adjacent commas. The empty field would be between those, if it were present. For two adjacent empty FIELDS you would use 3 adjacent commas, and so on.
A sample? Just to test this? You can do to a data site (US Census, etc) and download some CSVs if you like. Or just type one out in a TXT file with TextEdit. Just commands and returns, like this would work. A,B,C 1,2,3 4,5,6
Please do a tutorial on Merging csv files into a master csv where quantities are combined if all headers are the same. Ie 2 quantity in one sheet, 3 on the next. Same headers, so combines to 5
I would just import them all into Numbers (or Excel) and combine them there using formulas and other techniques. How easy that is depends on your spreadsheet skills.
I created a AI training on all system processes and predict data...then is ran through another process to save all the predicted data to another csv file to the specific columns I am now in the phase of creating the metadata for the predicted values for better overall system performance it's gonna be a game changer and I'm using python on a RTX 4090
@@Land-of-reason That's fine. You can do that. But put yourself in my shoes. Wikipedia and every single page on the first page of Google search results for "what does csv stand for" says it is "values." If I say "values" I get one complaint. But if I said "variables" I would definitely get more. I can't win, but I can at least go with the consensus. Oh, and here is another page at the same site (IBM) that says it is values: www.ibm.com/docs/en/bpmoc?topic=SS964W/com.ibm.wbpm.wid.data.doc/topics/ccsv.htm
A CSV file is a table where the fields that make up that table are delimited with a ‘comma’. Within the context of a programme a ‘value’ will have a specific meaning. Within the context of a 70’s HP2100 or 21MX computer the value ‘102077’ octal meant ‘stop’. If you have a table of ‘Comma Separated Values’ each line within that file would represent the same thing - the stop code which would be nonsense. Despite what Wikipedia may claim the fields within the table must be variables and not values.
When someone who's never used anything like that gets a notice to say, put your passwords into csv files and they've all been removed from you by Google; what do you then? There's a box to click for CSV and when I click it, all I get are files from my photo album. No good.
Thanks for this. For some reason, I was always a bit afraid of these type of documents. You helped to really demystify them with this video. Kind thanks!
CSV format is very useful. Also useful is separating the data in the columns on each line with the tab character. Numbers and most spreadsheets handle this with no problems.
Nobody makes such clear videos full of useful information (even though you think you know everything about a certain topic already). Thanks Gary. It's always worth watching.
Thanks!
@@macmost My pleasure. I also like that your videos do without effects and annoying music. Thanks again man.
thank you i used them in the past but your explanation was better than any other i have had. so thank you
I have a Job interview that is requiring CSV knowledge and before watching this video I didn't know anything about it. Thanks.
It is very convenient to have this simple CSV format that is not tied to a particular spreadsheet app for storing data. Some programming languages, such as Python, have some functionality, in the form of additional packages, that enable you to read CSV files, analyze them, and generate plots from them. For example, if the first column is Date and the second column is High Temperature, you can create a plot that shows high temperature as a function of date.
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Very useful. Thanks for the tips. Quotes around text fields is definitely the way to go
Very easily understandable and useful!
Best, good one. Thanks
Until this moment, only knew I couldn’t ever open these files.
Saaaame
Why did you think you coulnt open them🤨
Thanks very much, Gary, for this very interesting and informative video!
Thank you! I’m very happy to have learned about this! 😊
Nice beginner tutorial
Very helpful, thank you!
Thumbs up before even listening ❤
Great explanation...Thanks so much...
Thank you! I did not know about the plaint text mode in TextEdit.
I use a backslash (\) to delimit, and I find LibreOffice helpful when opening a CSV file because it prompts me up front to specify how the fields are separated (fixed length or what delimiters).
I try to import huge data from some app, the excel file is too small for it as data has 65 mln rows, so I save it as txt file, but when I open it there is some html tags and no data, is it possible to resolve this problem, Please?
Probably. You'd have to work at it. Examine the file, clean it up using various techniques, etc. What do you do depends on what is in the file. It will take skills and hard work.
Interesting. Useful.
Great video
Do you have a video on how to take CSV file and have them print on Avery address labels with an iMac
You'd either need to import it into an Avery template and work with it there. Or, get some label-printing software that handles it.
thanks for explaining about the quotes and commas for values - do you know anything about syntax errors from csv into consumer ui like mailchimp? couldn't import from csv because of syntax errors
You'd have to talk to MailChimp support about that...
Great video. How would you import CSV data into an existing Numbers spreadsheet that has formulae within it? Thanks again. Martin
Import into a table. Have the formulas that work on the data in other tables.
Thank you!
Great thing also about csv and text files is that they are very small files
In windows 10, I often make a folder full of movies, or other MP4 files. I do not create a CSV file, but when I list the files in the folder, there is a good CSV file among all these MP4s, listing all of the MP4s. I’m not sure if Windows creates that, or if the downloading software I use creates it. Has anyone else experienced this automatic appearance of a CVS file?
Great ! Question how do I take a pdf and change it into a csv file which can then open in numbers?
Just google "convert PDF to CSV"
The best way is usually copy and paste. You can sometimes do it right into Numbers. If that doesn't work paste it into a text document and clean it up there first.
@@macmost thanks - love your courses and YT videos ❤️👍
Thanks bunches
I have a CSV file and instead of a percentage I am just trying to increase the overall price of every item by one pound only but struggling to get it to work, I used to be able to do this years ago but just cannot recall how I did it, any help would be massively welcome.
So what app are you using? In most spreadsheet apps, you just add one. Like B2+1
Using softmaker at the moment and it really has me scratching my head, old age must be kicking in lol@@macmost
It seems rare to find in references, directions on how to represent an EMPTY field within a record. If anyone needs to know, the way to do that is by using 2 adjacent commas. The empty field would be between those, if it were present. For two adjacent empty FIELDS you would use 3 adjacent commas, and so on.
How do I have a sample of CSV for the first step?please
A sample? Just to test this? You can do to a data site (US Census, etc) and download some CSVs if you like. Or just type one out in a TXT file with TextEdit. Just commands and returns, like this would work.
A,B,C
1,2,3
4,5,6
Please do a tutorial on Merging csv files into a master csv where quantities are combined if all headers are the same.
Ie 2 quantity in one sheet, 3 on the next. Same headers, so combines to 5
I would just import them all into Numbers (or Excel) and combine them there using formulas and other techniques. How easy that is depends on your spreadsheet skills.
How do I paste text into extreme CSV? I can't make it work...
Not sure what you mean by "extreme" CSV.
Why formulas are missing when saved as csv??
CSV documents aren't full spreadsheets and just have the values in them, not formulas. Formulas would be specific to an app like Excel or Numbers.
I created a AI training on all system processes and predict data...then is ran through another process to save all the predicted data to another csv file to the specific columns I am now in the phase of creating the metadata for the predicted values for better overall system performance it's gonna be a game changer and I'm using python on a RTX 4090
I use CSV files to create Anki flashcards quickly!
thankss..
Comma Separated Variables!
Values. See en.wikipedia.org/wiki/Comma-separated_values
@@Land-of-reason That's fine. You can do that. But put yourself in my shoes. Wikipedia and every single page on the first page of Google search results for "what does csv stand for" says it is "values." If I say "values" I get one complaint. But if I said "variables" I would definitely get more. I can't win, but I can at least go with the consensus. Oh, and here is another page at the same site (IBM) that says it is values: www.ibm.com/docs/en/bpmoc?topic=SS964W/com.ibm.wbpm.wid.data.doc/topics/ccsv.htm
A CSV file is a table where the fields that make up that table are delimited with a ‘comma’.
Within the context of a programme a ‘value’ will have a specific meaning.
Within the context of a 70’s HP2100 or 21MX computer the value ‘102077’ octal meant ‘stop’. If you have a table of ‘Comma Separated Values’ each line within that file would represent the same thing - the stop code which would be nonsense.
Despite what Wikipedia may claim the fields within the table must be variables and not values.
When someone who's never used anything like that gets a notice to say, put your passwords into csv files and they've all been removed from you by Google; what do you then? There's a box to click for CSV and when I click it, all I get are files from my photo album. No good.
Not sure what you are dealing with there. This is about CSV files, but has nothing to do with Google passwords.
I thought it stood for comma separated VARIABLES.
Nope. en.wikipedia.org/wiki/Comma-separated_values
@ Thank you.
I am worried that i am in trouble understand
Kirk Trail
This is all a foreign language to me and Google took my passwords away from me. All of them.
You miss-spelled Google, as goggle
46736 Beer Union