Understanding CSV Files
Вставка
- Опубліковано 6 сер 2024
- macmost.com/e-2922 CSV files are plain text files that contain spreadsheet data. They are useful for importing or saving data regardless of the spreadsheet app you are using.
FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ UA-cam - macmost.com/j-youtube (And hit the 🔔)
▶︎ UA-cam Email Notifications - macmost.com/ytn ⭐️
▶︎ MacMost Weekly Email Newsletter - macmost.com/newsletter ✉️
SUPPORT MACMOST AT PATREON
▶︎ macmost.com/patreon ❤️
00:00 Intro
00:20 What Are CSV Files?
01:11 Both a Text File and a Spreadsheet File
02:01 Setting the Default App To Open a CSV File
03:46 Quotation Marks In CSV Files
04:28 Exporting To a CSV File
#macmost #mactutorial - Наука та технологія
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.
thank you i used them in the past but your explanation was better than any other i have had. so thank you
Very useful. Thanks for the tips. Quotes around text fields is definitely the way to go
A very useful and informative video tutorial today! Thank you, Gary! 👏🏻❤️
Thank you! I’m very happy to have learned about this! 😊
I have a Job interview that is requiring CSV knowledge and before watching this video I didn't know anything about it. Thanks.
Very easily understandable and useful!
Thanks very much, Gary, for this very interesting and informative video!
Great explanation...Thanks so much...
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.
Very helpful, thank you!
Nice beginner tutorial
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).
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!
Great thing also about csv and text files is that they are very small files
Until this moment, only knew I couldn’t ever open these files.
Saaaame
Interesting. Useful.
Great video
Thanks bunches
Thumbs up before even listening ❤
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.
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
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.
I use CSV files to create Anki flashcards quickly!
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.
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 ❤️👍
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
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
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.
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.
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 am worried that i am in trouble understand
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