Python for Spreadsheets and CSV File manipulation - Part 1 Basics

This video is the first part of the mini-series of how to use the python programming language with spreadsheets or CSV types of files.

The main reason why you would want to use a programming language like python to help you with your spreadsheets is it can actually become easier to use python than a typical spreadsheet program. This happens when you want to use extensive formulas or even apply a little bit of coding logic to the spreadsheet's cells.

[sentdex]

Happy to return the favor. Much of what I learned has been due to the kindness of others to share knowledge.

[sentdex]

My issue with ipython notebook is that it teaches mostly scripting. It's a lot like programming in the command prompt, where you are going line by line. I think a lot of it depends on how you started. It's definitely a good way to constantly debug a script as you go.

[allansyiek]

I get a 404 when I try the TutSheet url. Can u plz post a valid link?

[prasaddalavi]

can we read continuosly updated csv file in python with the same real time updates at the output? I mean to say if suppose the csv file is getting updated every 5 sec can we read that updated data automatically in the same program?

[trench]

Should I use pandas or csv module to manipulate csv files? I am not so familiar with either but I would rather learn the best one for my needs:
1) Work with large csv files (back tracked data would be 2-10g each probably, but moving forward it would just be daily updates of small files)
2) Only 'extract' certain columns
3) Hopefully find and replace certain values (like if 'City' = 106 then it is NY, for example)
4) Add a column with certain calculations (like summing 3 columns and dividing by 60, for example)

I will then import those files into Tableau data extracts for analysis. 

[RonJohn]

2:03 or get it from your package manager.

[yoco]

How can I Replace Strings based on column number in CSV? I mean if the value is 0 in column 2 i need to replace it with null?

[murtazahaji]

Hi bro im trying to import csv using python pandas but my csv is broken due to extra commas in fields i want to know if i can parse the data in csv in reverse. This will let me get the column i require with proper data and the errors will occur in the following columns, i can then extract only that column and use it

[rishabhsharma]

How do i download the csv file. I can't find it on the link provided

[rishinethpanda]

hey whats the stuff with your browser it looks interesting while crashing .please tell me what it is.

[ramakanthrayanchi]

I could not find the TutSheet.csv from the video. Could anyone please help me.

[ProfessorMalik]

How woud i be able to add another sheet to the same file?

[jamesboom]

is it possible to show individual information form each row and columns 

[Iridescent-rb]

Thank you so much! Actually one thing on my mind is that what is the 'try ...except' for ? thanks!!

[karina]

there are syntaxes that are not supported, that are invalid in python3.6, except Exception, e: and print str(e)

[litigationsupporttipofthen]

When I try to run this for a very large csv file I get an error message reading, "need more than 3 values to unpack" after entering print Control, Bates, Text.   Do you know how to fix this problem?

[PASHAAMU]

Hi, can you please help in resolving a problem that is assigned to me

[DeepakAnandani]

Hello @sentdex thank you for all the python tutorials you have uploaded, well i had a question, i am working a project of sentiment analysis and using python, I am a beginner and reached till importing a CSV file, i have 7500 rows of tweets in a CSV, and some tweets are in different language. please help in how can i change the language in English. and also how to apply regular expression on that tweets.

Thank you

[bunkdinho]

Great video! I am running 2.7.8 64-bit, but I keep getting the ***keyword can't be an expression when I first try to print the date. Any thoughts?

[ShilpiBhargavaiitb]

it says setup program is invalid or damaged.