Replacing a column in a table with values dependent on the current values in the column? The...
Should I use my personal e-mail address, or my workplace one, when registering to external websites for work purposes?
What does Linus Torvalds mean when he says that Git "never ever" tracks a file?
Landlord wants to switch my lease to a "Land contract" to "get back at the city"
Pokemon Turn Based battle (Python)
Why can Shazam fly?
How come people say “Would of”?
If a Druid sees an animal’s corpse, can they Wild Shape into that animal?
Output the Arecibo Message
What is the meaning of the verb "bear" in this context?
Why did Acorn's A3000 have red function keys?
How to notate time signature switching consistently every measure
Is an up-to-date browser secure on an out-of-date OS?
Does coating your armor in silver add any effects?
Shouldn't "much" here be used instead of "more"?
How to save as into a customized destination on macOS?
Can we generate random numbers using irrational numbers like π and e?
Button changing it's text & action. Good or terrible?
What do the Banks children have against barley water?
Is there a symbol for a right arrow with a square in the middle?
Where to refill my bottle in India?
What is the motivation for a law requiring 2 parties to consent for recording a conversation
Identify boardgame from Big movie
Looking for Correct Greek Translation for Heraclitus
Which Sci-Fi work first showed weapon of galactic-scale mass destruction?
Replacing a column in a table with values dependent on the current values in the column?
The 2019 Stack Overflow Developer Survey Results Are InTable with dependent iteratorHow can I make the Cartesian product of a list with itself?Replacing all values in a table > $T$How to make an efficient difference of sets function?Replacing values above a threshold with 1Joining table of tuples with table of scalar valuesHow to make a table with a jump in range?Remove rows in table that have rows with missing valuesAdding extra column to an existing tableCombine list with table
$begingroup$
I currently have a table of absorbances vs. wavenumbers. How would I change that to a table of %transmittances vs. wavenumbers? The relationship is given by
%Transmittance = (10^(-absorbance))*100]
I've tried:
newtable = Replace[currenttable, i -> ((10^(-i))*100)]
No errors occur, but nothing happens.
list-manipulation
edited yesterday
m_goldberg
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
add a comment |
$begingroup$
I currently have a table of absorbances vs. wavenumbers. How would I change that to a table of %transmittances vs. wavenumbers? The relationship is given by
%Transmittance = (10^(-absorbance))*100]
I've tried:
newtable = Replace[currenttable, i -> ((10^(-i))*100)]
No errors occur, but nothing happens.
list-manipulation
edited yesterday
m_goldberg
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
2
$begingroup$
You may usenewtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100;whereiis the number of the column. If you wonder what[[ ]]is, look upPartin the documentation.
$endgroup$
– Henrik Schumacher
yesterday
2
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
3
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday
add a comment |
$begingroup$
I currently have a table of absorbances vs. wavenumbers. How would I change that to a table of %transmittances vs. wavenumbers? The relationship is given by
%Transmittance = (10^(-absorbance))*100]
I've tried:
newtable = Replace[currenttable, i -> ((10^(-i))*100)]
No errors occur, but nothing happens.
list-manipulation
edited yesterday
m_goldberg
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
I currently have a table of absorbances vs. wavenumbers. How would I change that to a table of %transmittances vs. wavenumbers? The relationship is given by
%Transmittance = (10^(-absorbance))*100]
I've tried:
newtable = Replace[currenttable, i -> ((10^(-i))*100)]
No errors occur, but nothing happens.
list-manipulation
list-manipulation
edited yesterday
m_goldberg
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
m_goldberg
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited yesterday
m_goldberg
88.5k873200
edited yesterday
m_goldberg
88.5k873200
edited yesterday
m_goldberg
88.5k873200
88.5k873200
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
asked yesterday
Christof Israel FontanillaChristof Israel Fontanilla
111
111
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Christof Israel Fontanilla is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2
$begingroup$
You may usenewtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100;whereiis the number of the column. If you wonder what[[ ]]is, look upPartin the documentation.
$endgroup$
– Henrik Schumacher
yesterday
2
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
3
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday
add a comment |
2
$begingroup$
You may usenewtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100;whereiis the number of the column. If you wonder what[[ ]]is, look upPartin the documentation.
$endgroup$
– Henrik Schumacher
yesterday
2
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
3
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday
2
2
$begingroup$
You may use
newtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100; where i is the number of the column. If you wonder what [[ ]] is, look up Part in the documentation.$endgroup$
– Henrik Schumacher
yesterday
$begingroup$
You may use
newtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100; where i is the number of the column. If you wonder what [[ ]] is, look up Part in the documentation.$endgroup$
– Henrik Schumacher
yesterday
2
2
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
3
3
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
Contrived data based on the element form {wave-number, absorbance}.
SeedRandom[42];
With[{n = 5}, data = Sort @ Transpose[{RandomInteger[100, n], RandomReal[1., n]}]]
{{4, 0.142803}, {6, 0.628702}, {15, 0.290081}, {54, 0.0292846}, {66, 0.105067}}
Assuming you want to keep the original data and not destructively change the 2nd column in it, you could proceed as follows:
newdata = data;
newdata[[All, 2]] = 100 10^-data[[All, 2]];
newdata
{{4, 71.9776}, {6, 23.5124}, {15, 51.2765}, {54, 93.4793}, {66, 78.5114}}
This works because all Mathematica's arithmetic operators have a property called Listable, which means they automatically map over lists such as data[[All, 2]]. In this case the operator doing the mapping is Power.
answered yesterday
m_goldbergm_goldberg
88.5k873200
$endgroup$
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "387"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Christof Israel Fontanilla is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f194857%2freplacing-a-column-in-a-table-with-values-dependent-on-the-current-values-in-the%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
Contrived data based on the element form {wave-number, absorbance}.
SeedRandom[42];
With[{n = 5}, data = Sort @ Transpose[{RandomInteger[100, n], RandomReal[1., n]}]]
{{4, 0.142803}, {6, 0.628702}, {15, 0.290081}, {54, 0.0292846}, {66, 0.105067}}
Assuming you want to keep the original data and not destructively change the 2nd column in it, you could proceed as follows:
newdata = data;
newdata[[All, 2]] = 100 10^-data[[All, 2]];
newdata
{{4, 71.9776}, {6, 23.5124}, {15, 51.2765}, {54, 93.4793}, {66, 78.5114}}
This works because all Mathematica's arithmetic operators have a property called Listable, which means they automatically map over lists such as data[[All, 2]]. In this case the operator doing the mapping is Power.
answered yesterday
m_goldbergm_goldberg
88.5k873200
$endgroup$
add a comment |
$begingroup$
Contrived data based on the element form {wave-number, absorbance}.
SeedRandom[42];
With[{n = 5}, data = Sort @ Transpose[{RandomInteger[100, n], RandomReal[1., n]}]]
{{4, 0.142803}, {6, 0.628702}, {15, 0.290081}, {54, 0.0292846}, {66, 0.105067}}
Assuming you want to keep the original data and not destructively change the 2nd column in it, you could proceed as follows:
newdata = data;
newdata[[All, 2]] = 100 10^-data[[All, 2]];
newdata
{{4, 71.9776}, {6, 23.5124}, {15, 51.2765}, {54, 93.4793}, {66, 78.5114}}
This works because all Mathematica's arithmetic operators have a property called Listable, which means they automatically map over lists such as data[[All, 2]]. In this case the operator doing the mapping is Power.
answered yesterday
m_goldbergm_goldberg
88.5k873200
$endgroup$
add a comment |
$begingroup$
Contrived data based on the element form {wave-number, absorbance}.
SeedRandom[42];
With[{n = 5}, data = Sort @ Transpose[{RandomInteger[100, n], RandomReal[1., n]}]]
{{4, 0.142803}, {6, 0.628702}, {15, 0.290081}, {54, 0.0292846}, {66, 0.105067}}
Assuming you want to keep the original data and not destructively change the 2nd column in it, you could proceed as follows:
newdata = data;
newdata[[All, 2]] = 100 10^-data[[All, 2]];
newdata
{{4, 71.9776}, {6, 23.5124}, {15, 51.2765}, {54, 93.4793}, {66, 78.5114}}
This works because all Mathematica's arithmetic operators have a property called Listable, which means they automatically map over lists such as data[[All, 2]]. In this case the operator doing the mapping is Power.
answered yesterday
m_goldbergm_goldberg
88.5k873200
$endgroup$
Contrived data based on the element form {wave-number, absorbance}.
SeedRandom[42];
With[{n = 5}, data = Sort @ Transpose[{RandomInteger[100, n], RandomReal[1., n]}]]
{{4, 0.142803}, {6, 0.628702}, {15, 0.290081}, {54, 0.0292846}, {66, 0.105067}}
Assuming you want to keep the original data and not destructively change the 2nd column in it, you could proceed as follows:
newdata = data;
newdata[[All, 2]] = 100 10^-data[[All, 2]];
newdata
{{4, 71.9776}, {6, 23.5124}, {15, 51.2765}, {54, 93.4793}, {66, 78.5114}}
This works because all Mathematica's arithmetic operators have a property called Listable, which means they automatically map over lists such as data[[All, 2]]. In this case the operator doing the mapping is Power.
answered yesterday
m_goldbergm_goldberg
88.5k873200
edited yesterday
answered yesterday
m_goldbergm_goldberg
88.5k873200
answered yesterday
m_goldbergm_goldberg
88.5k873200
answered yesterday
m_goldbergm_goldberg
88.5k873200
88.5k873200
add a comment |
add a comment |
Christof Israel Fontanilla is a new contributor. Be nice, and check out our Code of Conduct.
Christof Israel Fontanilla is a new contributor. Be nice, and check out our Code of Conduct.
Christof Israel Fontanilla is a new contributor. Be nice, and check out our Code of Conduct.
Christof Israel Fontanilla is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Mathematica Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f194857%2freplacing-a-column-in-a-table-with-values-dependent-on-the-current-values-in-the%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
$begingroup$
You may use
newtable = currenttable; newtable[[All, i]] = (10^(-newtable[[All, i]]))*100;whereiis the number of the column. If you wonder what[[ ]]is, look upPartin the documentation.$endgroup$
– Henrik Schumacher
yesterday
2
$begingroup$
Is the table structured as a list of pairs in form {wave-number, absorbance}?
$endgroup$
– m_goldberg
yesterday
3
$begingroup$
If you could show a brief excerpt of your table in your question, it would be easier to help you more effectively.
$endgroup$
– MarcoB
yesterday