I have multiple csv files to read and create a table with one or two headerlines. (parameters/units) I would like to use two header lines from this files using \pgfplotstabletypeset. Can anyone help me? It would be enough to give a parameter containing the number of header lines to extract.   \pgfplotstabletypeset[                 %skip first n=1,                 col sep=comma, % the seperator in our .csv file                 every head row/.style={before row={\toprule}, after row={\midrule}},                 every last row/.style={after row=\bottomrule},              ]{test.csv}
I have a dataset in csv file format that I'm loading into pgfplotstable. I can't change the format of the original csv, and being financial data it has a column of item names and two or three explanatory data points at the top of the table. e.g.  \documentclass{article} \usepackage{array,datatool,pgfplotstable}   \begin{filecontents}{sample.csv}     item,2008,2009,2010,2011      ,Actual,Actual,Forecast,Forecast      ,GBP,GBP,GBP,GBP      ,('000),('000),('000),('000) rounded     Area 1 OP, 1000000,1500000,1750000,250000     Area 2 OP, 400000,500000, 450000,-50000     Area 51 OP, 300000,375000,390000,15000     No P, 1250000, 1000000, 950000, 50000     Residuals, 800000, 80000, 90000, 10000   \end{filecontents}  \pgfplotstableread[col sep=comma]{sample.csv}\mystuff   I'm stumped at the next stage which is to typeset \mystuff so I have comma separators and can add a row that sums the 'Area' columns. At the moment to display the table I have to do something like  \begin{document}  \pgfplotstableread[col sep=comma,header=false]{sample.csv}\mystuff  \pgfplotstabletypeset[   columns/0/.style={string type},   columns/1/.style={string type},   columns/2/.style={string type},   columns/3/.style={string type},   columns/4/.style={string type}]\mystuff  \end{document}   How do I tag the top three rows as string and the rest of the last four columns as integer type so I can format and transform them?
Examples of topologies in which all open sets are regular? An open subset U of a space X is regular if it equals the interior of its closure, as we learn from the Wikipedia . Furthermore, the regular open subsets of a space (any space) form a complete Boolean algebra.  I'm coming to this from logic and algebra, with not much background in topology. I can't figure out which topologies have "interesting" collections of regular open sets. For example, in the trivial topology and the discrete topology, every open set is regular, if I'm not mistaken. Those are not "interesting" topologies. I assume there are other topologies in which the space X and the null set are the only regular open sets. If so, those aren't "interesting" either, at least not with regard to their regular open ets.  I believe what I'm looking for is topologies in which every open set is regular, other than the ones I've just described.  Thanks for any help. How to redirect output to screen as well as a file? The school where I work has an S when it is an acronym (NEGS) it looks odd with an apostrophe to show ownership e.g. NEGS' tennis team...any thoughts? Use of a semicolon before and comma after "however" Several years ago, a previous boss told me to use a semicolon and comma with the word "however".  I've always questioned this and would like to know if the following random sentences are using the correct method.        Our plane was delayed overnight; however, the airlines reimbursed us for lodging.   It looks as though he's upset; however, she told me he always has that look on his face.   I want to find him a nice gift; however, I am a broke until payday.      Normally I would use a less "wordy" sentence in casual writing, but hopefully the example will suffice.  For example, on number 3 I would usually type:      I want to get him a nice gift, but I'm broke until payday. Writing to NTFS drive in Linux I've got an external USB drive that is formatted with NTFS mounted on ~/tmp.  I can read it just fine, but cannot write to it, even as root (temp is a folder on the USB drive):  [root@Plugbox temp]# touch test touch: cannot touch `test': Permission denied [root@Plugbox temp]#   However, if I do a cat /proc/mounts, it looks like I do have NTFS read/write support:  [root@Plugbox temp]# grep /dev/sdb1 /proc/mounts /dev/sdb1 /root/tmp ntfs rw,relatime,uid=0,gid=100,umask=02,nls=utf8,errors=continue,mft_zone_multiplier=1 0 0 [root@Plugbox temp]#   Finally, if I go to the folder above temp, it looks like I should have plenty of permissions to write to the folder:  [root@Plugbox tmp]# ls -al total 61500764 ... drwxrwxr-x 1 root users           0 Apr 19  2010 temp ... [root@Plugbox tmp]#   What am I missing? How to get correct scale values? The scale of my map is wrong, no matter what coordinate system I use in my project. The map and all objects show the correct coordinates but the scale of the map shows nonsense and the measurement tool gives wrong dimension.   The map should be like 1:10000 but qgis shows 1:1. Anyone an idea? Delete from uitableview + write to plist not working How to "freeze" a cloth animation at X frame? How would one freeze a simulated body at frame X and use it as a static mesh?  Following a , I've been able to do a cloth animation to my model, now I'd like to have that made static, without the use of the timeline.   The thing is, I'm modelling something that's not going to be an animation, but a static object (something like a statue/figurine). So I don't need the animation, only the shape at a particular frame that I find convenient. I'd like eventually once this is done, to also modify that deformed grid.   I've tried to follow what was said , but couldn't figure out what chipmasque was saying. I'm quite new to blender (been using it on and off, just enough to forget everything).  I'm using blender 2.63, if it is of any relevance. For $n$ a positive integer, let us write $\zeta_n = e^\frac{2 \pi i}{n}$, a primitive $n$th root of unity. It is clear that, if $m$ divides $n$, then we have an inclusion of cyclotomic fields $$ \mathbb{Q}(\zeta_m) \subseteq \mathbb{Q}(\zeta_n).$$ On the other hand, these inclusions are not always strict. For example, since $\zeta_3  = \frac{1+i \sqrt{3}}{2}$ and $\zeta_6 = \frac{-1 + i \sqrt{3}}{2}$, we have $$\mathbb{Q}(\zeta_3) = \mathbb{Q}(\zeta_6) = \mathbb{Q}(i\sqrt{3}).$$ Does this sort of thing happen infinitely often, or are there just some coincidences among small numbers? If this continues, is there some way to know when a particular inclusion of cyclotomic fields is strict? What is a good word to describe someone who is empathetic, quick, and witty in conversation Bad Eyesight and Evolution Why do many humans have bad eyesight, such as near-sightedness, which hampers performance in a wide variety of tasks? Shouldn't there be evolutionary pressure towards better eyesight? What happens when I hover over a link in Chrome? I'm not normally a fan of mac software implementations, but recently I saw a copy of Parallels Desktop for mac that I was very much impressed by. I looked into parallel's offerings for Linux (I was initially excited that they developed for *nix) but found that it has essentially the same features as VMware.   Does anyone know if there is a software solution for linux that offers the level of integration that the current Parallels Deesktop for mac has?  I looked into wine for the programs I want to run and was very frustrated. I feel like all the ratings in their application database were fabricated honesty. I've tried wine once every Ubuntu release since 8.10 and have never gotten it to work stably. What are some alternative launchers that can be used to launch programs in Ubuntu's default Unity desktop? Allow horizontal scrolling of long math expressions Stack Exchange formats math, but often the formatted math is wider than the screen. It would be nice if formatted math were scrollable the same way that formatted code wider than the screen is scrollable. I was recently invited to join InitiativeQ via a friend on Facebook. The underlying idea makes rough sense to me (as a non finance expert). However their 'hook' seems to be that early adopters will get free money later down the line when the currency launches (the earlier you adopt, the more currency you will receive). Looking at the website, there is a big button with the text Reserve $128,957 (I assume that's their idea of what the dollar value of my reservation will be if it launches).  The website's production quality suggests it is not a scam, however the language suggests strongly that it is. Is this a scam, a get rich quick scheme? Or am I being overly paranoid? How do you factorise $x^3z - x^3y - y^3z + yz^3 + xy^3 - xz^3$? I'm trying to factorise $$ x^3z - x^3y - y^3z + yz^3 + xy^3 - xz^3 $$ into four linear factors.  By plugging it into WolframAlpha I've learned that it's $$-(x-y)(x-z)(y-z)(x+y+z)$$  My question is: what are the steps involved in factorising the expression? Is there a method I don't know about that I'd have access to with my limited maths?  Really appreciate any help! Excel-Count number of visible cells containing certain string I have a sheet in which I first apply a filter to a certain column to show "Unique records only". Now I have a column which contains, for e.g., values like:  Applepie Applesauce Crabapple Banana Mango   What I need is the count of all visible cells containing the word "Apple". Note that this should exclude the hidden (filtered out) cells. Now I have found out a formula:  `=SUMPRODUCT(SUBTOTAL(3,OFFSET(Sheet1!A:A,ROW(Sheet1!A:A)-MIN(ROW(Sheet1!A:A)),,1))*(Sheet1!A:A="&lt;Text to search&gt;"))`   However the problem with this one is this formula searches for the entire text. NOT just a part of it. How do I modify this formula to return count of cells containing "Apple" i.e. for this example it should return 3 as the result. Is there a difference between "Alpha Helix" and "Alpha subunit"? postgresql - replace all instances of a string within text field