I have four files;  file1:  gene_id FPKM TRINITY_DN56960_c4_g1 36.91 TRINITY_DN42427_c0_g1 12.83 TRINITY_DN48728_c0_g1 6.22 TRINITY_DN50706_c0_g2 6604.75 TRINITY_DN51449_c1_g1 8.19 TRINITY_DN48996_c1_g1 28.21   file2:  gene_id FPKM TRINITY_DN48728_c0_g1 6.05 TRINITY_DN50706_c0_g2 5176.34 TRINITY_DN51449_c1_g1 7.58 TRINITY_DN48996_c1_g1 16.47 TRINITY_DN42427_c0_g1 14.03 TRINITY_DN56960_c4_g1 80.91    file 3:  gene_id FPKM TRINITY_DN56960_c4_g1 90.91 TRINITY_DN42427_c0_g1 24.03 TRINITY_DN51449_c1_g1 6.58 TRINITY_DN48996_c1_g1 26.47 TRINITY_DN48728_c0_g1 7.05 TRINITY_DN50706_c0_g2 4176.34   file 4:  gene_id FPKM TRINITY_DN50706_c0_g2 9176.34 TRINITY_DN56960_c4_g1 120.91 TRINITY_DN42427_c0_g1 34.03 TRINITY_DN48728_c0_g1 7.05 TRINITY_DN51449_c1_g1 7.58 TRINITY_DN48996_c1_g1 36.5   I want the output file like this:  gene_id               FPKM1 FPKM2 FPKM3 FPKM4 TRINITY_DN42427_c0_g1 12.83 14.03 24.03 34.03 TRINITY_DN48728_c0_g1 6.22 6.05 7.05 7.05 TRINITY_DN48996_c1_g1 28.21 16.47 26.47 36.5 TRINITY_DN50706_c0_g2 6604.75 5176.34 4176.34 9176.34 TRINITY_DN51449_c1_g1 8.19 7.58 6.58 7.58 TRINITY_DN56960_c4_g1 36.91 80.91 90.91 120.91   So how can I do this in a shell script?
I have 100 files with 57,816 rows each.I want to do an outer join of these files by merging on basis of the common column.  I am using R programming for this but this is very slow.  fileList &lt;- list.files(, pattern=".txt") pm_list=lapply(fileList, read.table) merged_pm=merge_all(pm_list, by = "gene_short_name")   Is there any quick way to do this in bash? The other method that I can use is SQL but I have to create 100 tables first and then load them up before join,which is not very efficient way to do.  The number of rows are equal in each file, thats why I want to merge  based on common column and can't use cbind from R as the constants in the common column are a bit up and down in different files and not present at same location in each file.Below are two sample files.I want to join based on 'gene_short_name'  gene_short_name FPKM56  MT-TF   0.90 MT-TV   0 MT-RNR1 310.015 MT-TL1  0 MT-TM   0   File 2 is below:  gene_short_name FPKM53  MT-TF   0 MT-TV   0.344 MT-TM   0.10 MT-TL1  0 MT-RNR1 0 MT-ND2  158.332
At the end of . the author states that  Suppose we have $n \times n$ matrix $A$ having only positive elements and satisfying the property $a_{ij}=1/a_{ji}$ (a matrix satisfying this property is called a reciprocal matrix).  If its largest eigenvalue $\lambda_{max}$ is equal to $n$, then the matrix $A$ satisfies the property (consistency property) $a_{ij} a_{jk} = a_{ik}$ where $i,j,k=1,2,...,n$.  I'm not convinced this theorem is true. Could anyone help? Universal Chord Theorem Wrapfigure in an enumerate environment. I want to use wrapfigure in the enumerate environment. For example,   \documentclass[11pt, a4paper]{article} \usepackage{graphicx} \usepackage{float} \usepackage{wrapfig}  \begin{document} \normalsize {\bf Multiple Choice: } \begin{enumerate}     \item \begin{wrapfigure}{r}{4.5cm}           \includegraphics[scale=0.5]{Exam1_Fig1.jpg}           \end{wrapfigure}           As shown in the figure. This rock is phaneritic and contains quartz, K-feldspar, and plagioclase in nearly equal amounts. What is it? \\           (A) rhyolite \\           (B) basalt \\           (C) diorite \\           (D) ash-flow tuff \\           (E) granite \\ \end{enumerate} \end{document}   However, the figure inserted is not wrapped by the text, but put in a strange position. How to fix the problem?   Thank you! How do I remove "Ubuntu" in the bios boot menu? (UEFI) Is there any function that converts an escaped Url string to its unescaped form? System.Web.HttpUtility.UrlDecode() can do that job but I don't want to add a reference to System.Web.dll. Since my app is not a web application, I don't want to add a dependency for only using a function in an assembly.  UPDATE: Check  about the same issue. After the last update of TeXLive 2018 (pretest) I get an error with csquotes' macro MakeAutoQuote:  \setcounter{errorcontextlines}{100} \listfiles \documentclass[fontsize=11pt,paper=a4,pagesize,ngerman]{scrartcl} \usepackage[utf8]{inputenc} \usepackage{babel} \usepackage[T1]{fontenc} \usepackage{csquotes} \MakeAutoQuote{»}{«}  \begin{document} ABC \end{document}   The error:  ! Package csquotes Error: Invalid argument.   My versions:  inputenc.sty    2018/04/06 v1.3b Input encoding file babel.sty    2018/02/14 3.18 The Babel package csquotes.sty    2018/02/11 v5.2c context-sensitive quotations (JAW)   I use pdfLaTeX. What is wrong here? Topological/Geometrical justification for $\text{CFT}_2$ being special It is known as a fact that conformal maps on $\mathbb{R}^n \rightarrow \mathbb{R}^n$ for $n&gt;2$ are rotations, dilations, translations, and special transformations while conformal maps for $n=2$ are from a much wider class of maps, holomorphic/antiholomorphic maps. I was wondering to know if there is any topological or geometrical description for this.   To show what I mean, consider this example: in $\mathbb{R}^n$ for $n&gt;2$ interchanging particles can only change the wave function to itself or its minus. It is related to the fundamental group of $\mathbb{R}^n-x_0$ ($x_0$ is a point in $\mathbb{R}^n$ and $\pi_1(\mathbb{R}^n-\{x_0\})=e$ for $n&gt;2$) but this is not true for $n=2$.   I want to know whether exists any topological invariant or just any geometrical explanation that is related to the fact that I mentioned about conformal maps on $\mathbb{R}^n$. Should I install programs from a source tarball (`.tar.gz`), from the Ubuntu Software Centre, or from elsewhere? How I can recover files when the folder shows empty but the files are not deleted? Is there a way to disable WAC String for a specific link (ex. Tracking Link) with AMPscript or otherwise? When is a cellular automaton "bidirectional"? Terminal prompt overwrites current line Basically on my site I have a bunch of song lyrics and in a static page I want to show them listed by album  and album position of the song and I have two custom fields with that data, sd_album_title and `sd_album_track_n. Plus some of the songs don't have an album yet, so both values are void, and I wish to list those ones at the foot of the others, sorted by alphabetical order.  The latest thing I tried at least to sort everything by the two field is this one:  $key = 'sd_album_title'; $themeta = get_post_meta($post-&gt;ID, $key, TRUE);  add_filter( 'pre_get_posts', 'my_get_posts' ); function my_get_posts( $query ) {     if ($themeta != '') {         $query-&gt;set( 'post_type', 'lyric' );         $query-&gt;set( 'meta_key', 'sd_album_title' );         $query-&gt;set( 'orderby', 'meta_value' );         $query-&gt;set( 'order', 'ASC' );         $query-&gt;set( 'meta_query', array(               array(                     'key' =&gt; 'sd_album_title'               ),               array(                     'key' =&gt; 'sd_album_track_n',                     'value' =&gt; 'target_value',                     'compare' =&gt; '&gt;=',                     'type' =&gt; 'numeric'               )         ));     }     return $query; }  $getlist= 'my_get_posts'; $posts = get_posts( $getlist );   And my intention was to put an else at the end of it with an array ordered by title for the other songs, but it returns nothing as it is. Could something like this work with some corrections or am I on a totally wrong path? get list item by id using COM sharepoint 2013 I need to get item from list sharepoint by Id I use this code and it give me all the items of the list :  &lt;script&gt;  function parseURLParams(url) {         var queryStart = url.indexOf("?") + 1,             queryEnd = url.indexOf("#") + 1 || url.length + 1,             query = url.slice(queryStart, queryEnd - 1),             pairs = query.replace(/\+/g, " ").split("&amp;"),             parms = {}, i, n, v, nv;          if (query === url || query === "") {             return;         }          for (i = 0; i &lt; pairs.length; i++) {             nv = pairs[i].split("=");             n = decodeURIComponent(nv[0]);             v = decodeURIComponent(nv[1]);              if (!parms.hasOwnProperty(n)) {                 parms[n] = [];             }              parms[n].push(nv.length === 2 ? v : null);         }         return parms;     }  $( window ).load(function() {   var urlString = document.URL;  urlParams = parseURLParams(urlString);  ExecuteOrDelayUntilScriptLoaded(retrieveActualite, "sp.js");          var siteUrl = '/sites/securite';      function retrieveActualite() {              var clientContext = new SP.ClientContext(siteUrl);             var oList = clientContext.get_web().get_lists().getByTitle('Actualite');             var camlQuery = new SP.CamlQuery();              camlQuery.set_viewXml('&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name=”ID” LookupId="TRUE"/&gt;&lt;Value Type="Text"&gt;' + urlParams.IdArt[0] + '&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;/Query&gt;');             this.collListItem = oList.getItems(camlQuery);             clientContext.load(collListItem);             clientContext.executeQueryAsync(onQuerySucceededActualite, onQueryFailed);         }          function onQuerySucceededActualite(sender, args) {              var listItemInfo = '';              var listItemEnumerator = collListItem.getEnumerator();             while (listItemEnumerator.moveNext()) {                 var oListItem = listItemEnumerator.get_current();                   var desc=oListItem.get_item('Description');                 $('#idArticle').append('&lt;label class="titleArticle"&gt;'+oListItem.get_item('Title')+'&lt;/label&gt; &lt;br&gt;&lt;br&gt;&lt;p class="ContenuArticle" &gt;'+desc+'&lt;/p&gt;');                          }         }          function onQueryFailed(sender, args) {              alert('Request failed. ' + args.get_message() + '\n' + args.get_stackTrace());         }       });    &lt;/script&gt;   so how can I get only the considered item ? How do I get the feature id after featureAdded signal (PyQGIS)? I'm trying to make an edit form in QGIS (Python code) ,and i want after feature drawing to get the id, and the feature to be selected. Do you have any ideas to do that?  Tried so far:  self.iface.activeLayer().featureAdded.connect(self.myfonction)  def myfonction(self):      for feat in self.iface.activeLayer().getFeatures():         self.iface.activeLayer().setSelectedFeatures([feat.id()]) Why can't a CNAME record be used at the apex (aka root) of a domain? This is a  about CNAMEs at the apices (or roots) of zones   It's relatively common knowledge that CNAME records at the apex of a domain are a taboo practice.  Example: example.com. IN CNAME ithurts.example.net.  In a best case scenario nameserver software might refuse to load the configuration, and in the worst case it might accept this configuration and invalidate the configuration for example.com.  Recently I had a webhosting company pass instructions to a business unit that we needed to CNAME the apex of our domain to a new record. Knowing that this would be a suicide config when fed to BIND, I advised them that we would not be able to comply and that this was bunk advice in general. The webhosting company took the stance that it is not outright forbidden by standard defining RFCs and that their software supports it. If we could not CNAME the apex, their advice was to have no apex record at all and they would not provide a redirecting webserver. ...What?  Most of us know that  insists that A CNAME record is not allowed to coexist with any other data., but let's be honest with ourselves here, that RFC is only Informational. The closest I know to verbiage that forbids the practice is from :     If a CNAME RR is present at a node, no other data should be   present; this ensures that the data for a canonical name and its aliases   cannot be different.   Unfortunately I've been in the industry long enough to know that "should not" is not the same as "must not", and that's enough rope for most software designers to hang themselves with. Knowing that anything short of a concise link to a slam dunk would be a waste of my time, I ended up letting the company get away with a scolding for recommending configurations that could break commonly used software without proper disclosure.  This brings us to the Q&amp;A. For once I'd like us to get really technical about the insanity of apex CNAMEs, and not skirt around the issue like we usually do when someone posts on the subject.  is off limits, as are any other Informational RFC applicable here that I didn't think of. Let's shut this baby down. Categorize my data into 3 groups Show that$\displaystyle\sum_{n=1}^\infty\frac{\sin( nz)}{n}$ diverges if $\mathfrak{Im} \,(z)\neq0$ We have to show that$\displaystyle\sum_{n=1}^\infty\frac{sin( nz)}{n}$ diverges if $Im\,(z)\neq0$  My try:$$\sin (nz) = \mathfrak{Im}(e^{nzi})$$  $$\sum_{n=1}^{\infty} \frac{\sin nz}{n} = \mathfrak{Im} \sum_{n=1}^{\infty} \frac{(e^{zi})^n}{n} = - \mathfrak{Im} \ln\left(1-e^{zi}\right). $$ Then how to proceed? This is a Putnam Problem that I have been trying to solve (on and off) for two years, but I have failed. I am in Calculus BC. This problem comes from the book "Calculus Eighth Edition by Larson, Hostetler, and Edwards". This problem is at the end of the first section of the chapter 8 exercises. Here's the problem:  Evaluate $$\int_2^4 \frac{\sqrt{\ln(9-x)}\,dx}{\sqrt{\ln(9-x)} + \sqrt{\ln(x+3)}}.$$  Please. Any help is very much appreciated. So are solutions. Thank you!  Edit: I like the solution given, but I was interested to see if there is any other way of doing the problem? I'm excited to see the results. How can I completely remove all traces of Java on my system?   I already know  in case I need it again.