How can I convert a dataset of numbers into a dataset of logarithms of these numbers

40 次查看（过去 30 天）
Panty
Panty 2014-7-2
评论： Star Strider 2014-7-5
Hi
I have imported an Excel dataset of real-time GDP. Which is a dataset of numbers in a triangular format.
So I want to convert this dataset into logs of these numbers. Is there any fast way??
Many thanks
  3 个评论
显示 1更早的评论
Panty
Panty 2014-7-2
The problem is that I am totally newly with matlab. How can I use the log function for the whole dataset?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2014-7-2
You need to load the dataset into the MATLAB workspace (use xlsread), then simply use the logarithm function of your choice on the entire dataset. Your options are: log (Napierian logarithms), log2 (base 2 logarithms), or log10 (base 10 logarithms). Then save to the file type of your choice. (I suggest a ‘.mat’ file,)
For example:
DataSet = randi(10, 5, 3)
LogDataSet = log10(DataSet)
  13 个评论
显示 11更早的评论
Panty
Panty 2014-7-5
I see your point.. I will try to use the table function. It may well works for me. I will let you know.
Much appreciated !!
Star Strider
Star Strider 2014-7-5
My pleasure!
The dataset class may be very useful in some situations, but it has serious limitations with respect to doing the sort of operation you want to do. The table class is also a core MATLAB set, and so likely portable amongst a number of different applications. I didn’t try table with your data, but I’ll give it a go if you have problems with it in your application.

请先登录，再进行评论。

更多回答（1 个）

Panty
Panty 2014-7-2
I have already imported the dataset using 'Import Data' button and I have the dataset in my workspace with 'Value' dataset. And ROUTPUTQvQ19652014 is the name of my dataset.
I used: logReal_GDP= log10(ROUTPUTQvQ19652014)
BUT I GOT : Undefined function 'log10' for input arguments of type 'dataset'.

类别

在 Help Center 和 File Exchange 中查找有关 Managing Data 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by