CSV Data: Comma Separated Values

Loading...

En provenance du cours de Duke University

Java Programming: Solving Problems with Software

1913 notes

Duke University

Java Programming: Solving Problems with Software

1913 notes

Cours 1 sur 4 dans Specialization Object Oriented Programming in Java

Learn to code in Java and improve your programming and problem-solving skills. You will learn to design algorithms as well as develop and debug programs. Using custom open-source classes, you will write programs that access and transform images, websites, and other types of data. At the end of the course you will build a program that determines the popularity of different baby names in the US over time by analyzing comma separated value (CSV) files. After completing this course you will be able to: 1. Edit, compile, and run a Java program; 2. Use conditionals and loops in a Java program; 3. Use Java API documentation in writing programs. 4. Debug a Java program using the scientific method; 5. Write a Java method to solve a specific problem; 6. Develop a set of test cases as part of developing a program; 7. Create a class with multiple methods that work together to solve a problem; and 8. Use divide-and-conquer design techniques for a program that uses multiple methods.

À partir de la leçon

CSV Files and Basic Statistics in Java

A common format for storing tabular data (any data organized into columns and rows) is in comma separated values (CSV) files. In this module, you will learn how to analyze and manipulate data from multiple CSV data files using a powerful open-source software package: Apache Commons CSV. Using this library will empower you to solve problems that could prove too complex to solve with a spreadsheet. By the end of this module, you will be able to: (1) Use the open-source Apache Commons CSV package in your own Java programs; (2) Access data from one or many CSV files using Java; (3) Convert strings into numbers; (4) Understand how to use “null” in Java programs (when you want to represent “nothing”); (5) Devise an algorithm (and implement in Java) to answer questions about CSV data; and (6) Analyze CSV data across multiple CSV files (for example, find maximums, minimums, averages, and other simple statistical results).

CSV Data: Comma Separated Values2:47

Using CSV Libraries7:11

Which Countries Export...? Developing an Algorithm4:14

Which Countries Export...? Translating into Code5:28

CSVExport: Summary0:48

Rencontrer les enseignants

Owen Astrachan
Professor of the Practice
Computer Science
Robert Duvall
Lecturer
Computer Science
Andrew D. Hilton
Assistant Professor of the Practice
Electrical and Computer Engineering
Susan H. Rodger
Professor of the Practice
Computer Science

Hello, and welcome to this introduction to using Java to help find trends,

patterns, and make a conclusion about information found in data.

You see here, two screenshots of

spreadsheet programs that have been used to analyze data over many, many years.

On the left, is a screenshot of a Google doc spreadsheet that you can use today.

This program analyzes data and runs in the cloud.

It is accessible via a browser or

mobile app on all kinds of devices all over the world.

On the right is a screen shot of the first spreadsheet program

that launched in 1979 and ran only on Apple 2 computers.

In general, spreadsheet programs work on data formatted in rows and columns.

Tabular data you'll be able to write Java code to analyze such data as well.

Spread sheets revolutionized so many industries and launched new ones by taking

seconds to model what if scenarios that are previously taken days to perform.

The link here is to a pod cast describing the development of visi calc and

the industries that have been transformed by these programs.

Today, data that can be analyzed by software programs is

often made publicly available through government and non-profit websites.

Typically, data is produced in CSV files, files in which the different data values

in each row are separated by commas, thus the name comma separated values.

You're going to learn how to write Java programs to analyze data

stored in CSV format.

Using spreadsheet software is a great way of finding patterns,

information, trends, and visualizing data.

But sometimes a spreadsheet program isn't enough to solve every problem easily.

There are many different spreadsheet programs, so a common format is useful.

The CSV format makes it possible for

data to be portable between different types of software to analyze data.

Furthermore, you can write your own Java programs to analyze

data using the CSV format.

Common formats often have standards.

For example the Internet Protocol or IP standard determines the format for

the packets that transport information across the internet.

The IETF or the Internet Engineering Task Force

that made the IP standard also created a standard for CSV files.

Other groups have made different but

related standards performance used in different software programs.

In this lesson you will learn how to use an open source software library

the Apache CSVParser.

As you learn more about Java programing.

This software library will allow you to solve problems that would be

really difficult to solve using just a spreadsheet.

Let's get started with this.

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2018 Coursera Inc. Tous droits réservés.

Télécharger dans l'App Store

Disponible sur Google Play