Join Club ShowMeDo to Learn Python!

This series is a part of Club ShowMeDo. Click to learn why you should join our club with a simple monthly subscription.

  • We teach Python and all the cool modules
  • Topics include beginner Python, GUIs, Web and Desktop Apps
  • Long, specially crafted video tutorials just for you
  • Club video tutorials extend our normal Free content
  • Save your time - we've done the research for you
  • Keep your skills up-to-date
  • Learn at your own pace, everything you need is shown to you
  • Over 12 hours of archived material are waiting for you in the club

Name: [002] Ian Ozsvald
Member: 107 months
Authored: 181 videos
Description: I am the co-founder of ShowMeDo (see http://showmedo.com/about), author of `The Screencasting Handbook <http://thescreencastinghandbook.com>`_ and the founder of the professional screencast production company `ProCasts <http://procasts.co.uk>`_: .. image:: http://procasts.co.uk/media/procasts_sma ...

Introducing .csv files and the Wing IDE [ID:243] (2/17)

in series: Python 101 - easygui and csv

(Showmedo is undergoing major changes. To report any problems viewing the videos please email us and include browser and OS specifics. Cheers - Kyran.)

The aim of this series is to build a working tool which reads a .csv file, creates averages, writes a new .csv file and does so with some nice user-interface controls. To begin we need to know about .csv files (csv at wikipedia) and we need to test our choice of IDE - Wing IDE.

We check that Wing's IDE works by writing a simple file and we execute both from inside Wing and from the DOS command line. If you have trouble with the command line then you might find this Python Newbies on XP series useful - it shows you how to use the command line, it also introduces the PyDev (free) IDE in Eclipse. We also have other PyDev and SPE videos.

Task: create measured.csv as shown in the video, create the simple csvReader.py file and check that you can execute it.

Created May 2007, running time: 8 minutes

Measured1,Measured2
22.3,24.2
22.1,24.3
22.4,23.9

Got any questions?

Get answers in the ShowMeDo Learners Google Group.

Video statistics:

  • Video's rank shown in the most popular listing
  • Video plays: 883 (since July 30th)
  • Plays in last week: 1
  • Published: 90 months ago

Thank-yous, questions and comments

If this video tutorial was helpful please take some time to say thank-you to the authors for their hard work. Feel free to ask questions. Let the author know why their video tutorial was useful - what are you learning about? Did the video tutorial save you time? Would you like to see more?

You may also want to see our ShowMeDo Google Group to speak to our active users and authors.

Your email address will not be published.

Show some quick comments >>








All comments excluding tick-boxed quick-comments

So, in this video you talk about filling up an excel file and about some other videos in this website... mmm


An index and resources would be particularly helpful for this video since you run off topic quite a bit:

CSV Files

Index of topics:

4:00 python run on command line

4:26 Other development environments - WING

4:56 Python Newbies on XP

5:20 PyDev

5:47 SPE - Stanley's(?) Python Editor

6:20 Running Python on XP

Resources:

http://en.wikipedia.org/wiki/Comma-separated_values

(fill in links to the other development environments here)


14. anonymous Sat, 08 Aug 2009 13:29

I can't figure out what Python is all about. I do want to convert a csv file to something I can use in Google Earth. In the Google tutorial they say to use Python but it looks to me like wild overkill to just put a path on the screen. I'm really new at programming (tho old in computer hardware design). I can't even figure out how to get a pre canned .kml file to show up in my google Earth! If I could I could probably just edit one of their path demos.


13. anonymous Mon, 03 Aug 2009 11:12

Great Site, Thanks for the Info!


Thanks, looks like it will be pretty basic, but fun series. I'm hoping to fill in a few holes in my understand.

So here's a question: I'm wondering IDE people are using. I use Linux and Windows. I mostly just gvim an the command line now, but have used Idle. I'm wondering about trying a more advanced IDE like Wing, SCE or Eclipse with pyDev.

Thanks,

Tim


Are you a paying member? This is one of our Club videos, you need to be a paying member to view/download them.

I've just tested the download link, it works fine for me, the file definitely exists.

Ian.


My network connection is a bit slow.

When I tried to download the video, the browers told me that the link is not valid.

Would you help me ?


Just beginning Python and having real-world need to handle CSVs, this was a good introduction to the general idea of tackling CSV files and the Python tools available.

I would not mind knowing a bit more about how some of the open source community free tools compare with Wing, especially ipython. I'm not sure I'm ready to appreciate Wing. Should I try and follow along with Wing101 for the time being?


I think it is a good idea to start from the basics.


Great, at least I learn something about the other ide's, but I am still stumbling, have the most luck with Boa-Constructor


Even for a beginner like me I had no problem understanding.

Nice work


Excellent presentation as always.


Hi Dave, welcome to the series. I think providing background information is important, I've added some more wikipedia links throughout the series.

Cheers,

Ian.


Nice quick intro to CSV files. Very clear explanation of what CSV is and how to go about creating a CSV file in Excel. I also like how you referenced wikipedia in this one - its good to show everyone external sources that may be helpful!


Yes, I like to link to wikipedia for background material. I think providing lots of background is a Good Thing as it helps us learn more about all these topics.

I figured that handling csv files was useful for scientists and students - it lends itself well to file-based experiments in files and could be immediately useful.

Re. other countries and csv files - yes, I'd forgotten about that. I used to work in Paris and the decimal-point and comma have reversed uses. Hmmm, I'm not sure there's an easy solution though?

Ian.


Wow, cool idea to quote wikipedia from within a video ! Have to check if wikipedia back-linked to you ...

I like the idea of an python program to handle csv-files. I remember that writing an lotus123-csv converter was the first program i wrote (in turbo pascal).

Note that german-language systems use the comma (",") as a decimal point sign and the point "." as an sign to distinct the thousend from hundreds. (we write 6.543,21 € meaning 6thousend-something Euro and 21 Cent) wich is always an extra-headache if you want to transfer such a number (from a string variable) into a number.


Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Ian

Content

Feedback

Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.

feedback@showmedo.com