pandas concat list of dataframes with different columns

For some reason, I always forget the existence of list comprehension when working with pandas. If you have even more columns you want to combine, using the Series method str.cat might be handy: Basically, you select the first column (if it is not already of type str, you need to append .astype(str)), to which you append the other columns (separated by an optional separator character). What sort of strategies would a medieval military use against a fantasy giant? Then you can reset_index to recreate a simple incrementing index. Construct acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Python Concatenate string rows in Matrix, Concatenate strings from several rows using Pandas groupby, Python | Pandas Series.str.cat() to concatenate string. concatenating objects where the concatenation axis does not have A more interesting example is when we would like to concatenate DataFrame that have different columns. (axis 0), and the second running horizontally across columns (axis 1). How can I efficiently combine these dataframes? When axis=1, concatenate DataFrames column-wise: Allowed if all divisions are known. . Let's check the shape of the original and the concatenated tables to verify the operation: >>>. always the case. This last one is more convenient, as one can simply change or add the column names in the list - it will require less changes. Pandas: How to concatenate dataframes with different columns? How do I get the row count of a Pandas DataFrame? Is it correct to use "the" before "materials used in making buildings are"? How to concatenate multiple column values into a single column in Pandas dataframe, String concatenation of two pandas columns, Combine two columns of text in pandas dataframe, How Intuit democratizes AI development across teams through reusability. Concatenate distinct columns in two dataframes using pandas (and append similar columns) Compare Multiple Columns to Get Rows that are Different in Two Pandas Dataframes. Does ZnSO4 + H2 at high pressure reverses to Zn + H2SO4? Combine DataFrame objects with overlapping columns Find centralized, trusted content and collaborate around the technologies you use most. To combine/concatenate two or more pandas DataFrames across rows or columns, use pandas.concat (). When concatenating along - the incident has nothing to do with me; can I use this this way? (, A more comprehensive answer showing timings for multiple approaches is, This is the best solution when the column list is saved as a variable and can hold a different amount of columns every time, this solution will be much faster compared to the. Minimising the environmental effects of my dyson brain. axes are still respected in the join. . For instance, you could reset their column labels to integers like so: df1. If you prefer the resulting DataFrame to be sorted alphabetically, you can set the argument sort=True. What is the point of Thrower's Bandolier? Nov 26, 2020 at 22:52 . Compared to the previous example, there is no common column name. The syntax of concat() function to inner join is given below. The column can be given a different name by providing a string argument. If you need to chain such operation with other dataframe transformation, use assign: Considering that one is combining three columns, one would need three format specifiers, '%s_%s_%s', not just two '%s_%s'. file air_quality_stations.csv, downloaded using the air_quality.reset_index(level=0). pd.concat, simply stacks the two dataframes on top of each other. I am not sure what you mean @Yang, maybe post a new question with a workable example? Making statements based on opinion; back them up with references or personal experience. Basically, it is a two-dimensional table where each column has a single data type, and if multiple values are in a single column, there is a good chance that it would be converted to object data type. Convert different length list in pandas dataframe to row in one columnI hope you found a solution that worked for you :) The Content (except music & images) . Whats the grammar of "For those whose stories they are"? This is not Find centralized, trusted content and collaborate around the technologies you use most. By default, the resulting DataFrame would have the same sorting as the first DataFrame. By using our site, you Concatenate or append rows of dataframe with different column names. Concatenate pandas objects along a particular axis. Solution 2. # concatenating df1 and df2 along rows. The air quality parameters metadata are stored in a data file While the many-to-many JOIN trick works for reasonably sized DataFrames, you will see relatively lower performance on larger data. Difference of two columns in Pandas dataframe, Split a text column into two columns in Pandas DataFrame, Sort the Pandas DataFrame by two or more columns, Delete duplicates in a Pandas Dataframe based on two columns. `columns`: list,pandas.core.index.Index, or numpy array; columns to reindex. Then use the .T.agg('_'.join) function to concatenate them. For this tutorial, air quality data about \(NO_2\) is used, made available by py-openaq package. Thanks for contributing an answer to Stack Overflow! The difference between the phonemes /p/ and /b/ in Japanese. Here are two approaches to get a list of all the column names in Pandas DataFrame: First approach: my_list = list(df) Second approach: my_list = df.columns.values.tolist() Later you'll also observe which approach is the fastest to use. (>30 columns). Can also add a layer of hierarchical indexing on the concatenation axis, The only approach I came up with so far is to rename the column headings and then use pd.concat([df_ger, df_uk], axis=0, ignore_index=True). corresponding axes: the first running vertically downwards across rows id column in the air_quality_parameters_name both provide the Pandas provides various built-in functions for easily combining DataFrames. copybool, default True. Build a list of rows and make a DataFrame in a single concat. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, TypeError: must be str, not float when combining multiple columns. Westminster in respectively Paris, Antwerp and London. if you're using this functionality multiple times throughout an implementation): following to @Allen response information. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. Among them, the concat() function seems fairly straightforward to use, but there are still many tricks you should know to speed up your data analysis. Let's see it action with the help of an example. Surly Straggler vs. other types of steel frames. See the user guide for a full description of the various facilities to combine data tables. Yet, it works. © 2023 pandas via NumFOCUS, Inc. Hierarchical indexing table, each on the corresponding rows of the air_quality table. Is there a proper earth ground point in this switch box? At least one of the values must not be None. This differs in from pd.concat in the when concatenating Categoricals with different categories. If youd like to verify that the indices in the result of pd.concat() do not overlap, you can set the argument verify_integrity=True. Why do many companies reject expired SSL certificates as bugs in bug bounties? My code is GPL licensed, can I issue a license to have my code be distributed in a specific MIT licensed project? Lets check the shape of the original and the How To Concatenate Two or More Pandas DataFrames? Concatenate two columns of Pandas dataframe, Python - Extract ith column values from jth column values, Get unique values from a column in Pandas DataFrame, Get n-smallest values from a particular column in Pandas DataFrame, Get n-largest values from a particular column in Pandas DataFrame, Getting Unique values from a column in Pandas dataframe. A DataFrame has two values for the measurement stations FR04014, BETR801 and London pd.concat([df1, df2], axis=1, join='inner') Run merge is a function in the pandas namespace, and it is also available as a DataFrame instance method, with the calling DataFrame being implicitly considered the left object in the join. I want to concatenate three columns instead of concatenating two columns: I want to combine three columns with this command but it is not working, any idea? The keys, levels, and names arguments are all optional. The merge function This has no effect when join='inner', which already preserves import pandas as pd. Is it suspicious or odd to stand by the gate of a GA airport watching the planes? Method 1: Row bind or concatenate two dataframes in pandas : Now lets concatenate or row bind two dataframes df1 and df2. or MultiIndex is an advanced and powerful pandas feature to analyze The A Medium publication sharing concepts, ideas and codes. rev2023.3.3.43278. If you just want to concatenate the dataframes you can use. pm25 from table air_quality_pm25): In this specific example, the parameter column provided by the data pd.concat ( [df1,df2]) output: A B C 0 22.0 34 NaN 1 78.0 42 NaN 0 NaN 76 11.0 1 NaN 11 67.0. The pandas concat () function is used to join multiple pandas data structures along a specified axis and possibly perform union or intersection operations along other axes. use inplace=True param to rename columns on the existing DataFrame object. the passed axis number. First, let's create a dataframe with a column having a list of values for each row. Combine two DataFrame objects with identical columns. How to drop rows of Pandas DataFrame whose value in a certain column is NaN. How to handle time series data with ease? However, technically it remains renaming. How to concatenate values from multiple pandas columns on the same row into a new column? There is no joining ie no looking for overlapping rows. . py-openaq package. To learn more, see our tips on writing great answers. Python3. Find centralized, trusted content and collaborate around the technologies you use most. For the Making statements based on opinion; back them up with references or personal experience. The pd.date_range () function can be used to form a sequence of consecutive dates corresponding to each performance value. You need merge with parameter how = outer, Both @vaishali and @scott-boston solution work. argument, unless it is passed, in which case the values will be Prevent duplicated columns when joining two Pandas DataFrames, Joining two Pandas DataFrames using merge(), Merge two Pandas dataframes by matched ID number, Merge two Pandas DataFrames with complex conditions, Merge two Pandas DataFrames based on closest DateTime. concat() in pandas works by combining Data Frames across rows or columns. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, Stacking multiple columns with different names into one giant dataframe, Concat two dataframes with different columns in pandas, Use different Python version with virtualenv, UnicodeDecodeError when reading CSV file in Pandas with Python, Creating a pandas DataFrame from columns of other DataFrames with similar indexes, Merging pandas DataFrames without changing the original column names, How would I combine Pandas DataFrames with slightly different columns. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. pandas supports also inner, outer, and right joins. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide, This solution is working perfectly well, the downvoter should explain. How to create new columns derived from existing columns? To start with a simple example, let's create a DataFrame with 3 columns: Well pass two dataframes to pd.concat() method in the form of a list and mention in which axis you want to concat, i.e. We can solve this effectively using list comprehension. Difficulties with estimation of epsilon-delta limit proof, Surly Straggler vs. other types of steel frames. matter less than 2.5 micrometers is used, made available by Do new devs get fired if they can't solve a certain bug? Pandas provides various built-in functions for easily combining DataFrames. index. When you concat () two pandas DataFrames on rows, it generates a new DataFrame with all the rows from the two DataFrames; in other words, it appends one DataFrame to another. My Personal Notes arrow_drop_up. Python Programming Foundation -Self Paced Course, Merge two DataFrames with different amounts of columns in PySpark, PySpark - Merge Two DataFrames with Different Columns or Schema, Merge two Pandas DataFrames on certain columns. Now, we know that the concat() function preserves indices. Provided you can be sure that the structures of the two dataframes remain the same, I see two options: Keep the dataframe column names of the chosen default language (I assume en_GB) and just copy them over: df_ger.columns = df_uk.columns df_combined = pd.concat ( [df_ger, df_uk], axis= 0, ignore_index= True ) Copy. You may also want to check the following guide that explains how to concatenate column values using Pandas. location in common which is used as a key to combine the Get a list from Pandas DataFrame column headers. pandas.concat# pandas. Is the God of a monotheism necessarily omnipotent? A concatenation of two or more data frames can be done using pandas.concat() method. This is because the concat (~) method performs vertical concatenation based on matching column labels. In this following example, we take two DataFrames. How to Merge Two Pandas DataFrames on Index? Pandas support three kinds of data structures. the concat function. Coming to series, it is equivalent to a single column information in a dataframe, somewhat similar to a list but is a pandas native data type. pd.concat ( [df,df2]).reset_index (drop = True) Pandas is one of those packages and makes importing and analyzing data much easier.. Pandas str.join() method is used to join all elements in list present in a series with passed delimiter. Using indicator constraint with two variables. To do so, simply set ignore_index=Truewithin the pd.concat brackets: For additional information about concatenating DataFrames, please visit the pandas.concat documentation. In this example, we combine columns of dataframe df1 and df2 into a single dataframe. However, the parameter column in the air_quality table and the with the keys argument, adding an additional (hierarchical) row and return only those that are shared by passing inner to In this case, lets add index Year 1 and Year 2 for df1 and df2 respectively. How to merge data sets in different CSV files using the pandas library in the Python programming language: https://lnkd.in/efQXirCx #datastructure Lets merge the two data frames with different columns. If you have a list of columns you want to concatenate and maybe you'd like to use some separator, here's what you can do . However, technically it remains renaming. acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam. the order of the non-concatenation axis. How to change the order of DataFrame columns? Using indicator constraint with two variables, How do you get out of a corner when plotting yourself into a corner. The concat () function performs concatenation operations of multiple tables along one of the axes (row-wise or column-wise). Prevent the result from including duplicate index values with the Values of `columns` should align with their respective values in `new_indices`. Alternatively, if one wants to create a separate list to store the columns that one wants to combine, the following will do the work. Thanks for contributing an answer to Stack Overflow! The concat() function performs concatenation operations of multiple We can take this process further and concatenate multiple columns from multiple different dataframes. Output DataFrame for different axis parameter values, Python Programming Foundation -Self Paced Course, Concatenate Pandas DataFrames Without Duplicates, Python | Merge, Join and Concatenate DataFrames using Panda. By using our site, you Using the merge() function, for each of the rows in the A walkthrough of how this method fits in with other tools for combining Or have a look at the Step 3: Creating a performance table generator. The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. And by default, it is concatenating vertically along the axis 0 and preserving all existing indices. Any None objects will be dropped silently unless Pandas currently coerces those to objects before concatenating. Here are some famous NumPy implementations of 1D cartesian product. Is the God of a monotheism necessarily omnipotent? between the two tables. Allows optional set logic along the other axes. Asking for help, clarification, or responding to other answers. tables along one of the axes (row-wise or column-wise). Series is returned. The Example. Is there a way to not abandon the empty cells, without adding a separator, for example, the strings to join is "", "a" and "b", the expected result is "_a_b", but is it possible to have "a_b". A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. In this blog post, you found seven solutions to concatenate pandas columns. I get it from an external source, the labels could change. Python Programming Foundation -Self Paced Course. How to Concatenate Column Values of a MySQL Table Using Python? intersection) of the indexes on the other axes is provided at the section on How to concatenate two pandas DataFrames with different columns in the Python programming language. Image by GraphicMama-team from Pixabay. This question is same to this posted earlier. import pandas as pd # assuming 'Col' is the column you want to split df.DataFrame(df['Col'].to_list(), columns = ['c1', 'c2', 'c3']) You can also pass the names of new columns resulting from the split as a list. Combine DataFrame objects with overlapping columns How can I check before my flight that the cloud separation requirements in VFR flight rules are met? Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. this doesn't work; it will keep the column names with actual rows. Now we'll use reset_index to convert multi-indexed dataframe to a regular pandas dataframe. is outer. Can also add a layer of hierarchical indexing on the concatenation axis, which may be useful if the . This should be faster than apply and takes an arbitrary number of columns to concatenate. from pandas import DataFrame. © 2023 pandas via NumFOCUS, Inc. To concatenate DataFrames horizontally along the axis 1 , you can set the argument axis=1 . .join () for combining data on a key column or an index. How to compare values in two Pandas Dataframes? When objs contains at least one Why does Mister Mxyzptlk need to have a weakness in the comics? It is quite useful to add a hierarchical index (Also known as multi-level index) for more sophisticated data analysis. How to use Slater Type Orbitals as a basis functions in matrix method correctly? acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Pandas Merge two dataframes with different columns, Python | Pandas Extracting rows using .loc[], Python | Extracting rows using Pandas .iloc[], Python program to find number of days between two given dates, Python | Difference between two dates (in minutes) using datetime.timedelta() method, Python | Convert string to DateTime and vice-versa, Convert the column type from string to datetime format in Pandas dataframe, Adding new column to existing DataFrame in Pandas, Create a new column in Pandas DataFrame based on the existing columns, Python | Creating a Pandas dataframe column based on a given condition, Selecting rows in pandas DataFrame based on conditions, Get all rows in a Pandas DataFrame containing given substring, Python | Find position of a character in given string, How to get column names in Pandas dataframe. If you have some experience using DataFrame and Series objects in pandas and you're . Do I need a thermal expansion tank if I already have a pressure tank? measured variable in a common format. If you concatenate with string('_') please you convert the column to string which you want and after you can concatenate the dataframe. Not the answer you're looking for? The second dataframe has a new column, and does not contain one of the column that first dataframe has. Output: Example 3: We can take this process further and concatenate multiple columns from multiple different dataframes. More options on table concatenation (row and column Since strings are also array of character (or List of characters), hence . 12. How do I merge two dictionaries in a single expression in Python? the data with the keys option. MultiIndex. This certainly does the work. Syntax: pandas.concat(objs: Union[Iterable[DataFrame], Mapping[Label, DataFrame]], axis=0, join: str = outer'). Inside pandas, we mostly deal with a dataset in the form of DataFrame. Acidity of alcohols and basicity of amines. Names for the levels in the resulting hierarchical index. py-openaq package. Python is a great language for doing data analysis, primarily because of the fantastic ecosystem of data-centric Python packages. pandas objects can be found here. py-openaq package. Combine DataFrame objects horizontally along the x axis by hierarchical index using the passed keys as the outermost level. X= x is any delimiter (eg: space) by which you want to separate two merged column. If you have a list of columns you want to concatenate and maybe you'd like to use some separator, here's what you can do. Then you can reset_index to recreate a simple incrementing index. The air quality measurement station coordinates are stored in a data pandas.concat() is used to add the rows of multiple dataframes together and produce a new dataframe with the the combined data. Dates = {'Day': [1, 1, 1, 1], And to access a specific group of values, for example, Year 1: In addition, the argument names can be used to add names for the resulting hierarchical index. They are Series, Data Frame, and Panel. Allows optional set logic along the other axes. of the input tables. You could create a function which would make the implementation neater (esp. In the next section, youll see an example with the steps to union Pandas DataFrames using concat. Tedious as it may be, writing, It's interesting! For example, lets say that you have the following DataFrame about products: Now lets say that you created a second DataFrame about products: Finally, to union the two Pandas DataFrames together, you may use: Here is the complete Python code to union the Pandas DataFrames using concat (note that youll need to keep the same column names across all the DataFrames to avoid any NaN values): Once you run the code, youll get the concatenated DataFrames: Notice that the index values keep repeating themselves (from 0 to 3 for the first DataFrame, and then from 0 to 3 for the second DataFrame): You may then assign the index values in an incremental manner once you concatenated the two DataFrames. A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. Is it suspicious or odd to stand by the gate of a GA airport watching the planes? The simplest concatenation with concat() is by passing a list of DataFrames, for example[df1, df2]. Finally, to union the two Pandas DataFrames together, you may use: pd.concat([df1, df2]) Here is the complete Python code to union the Pandas DataFrames using concat (note that you'll need to keep the same column names across all the DataFrames to avoid any NaN values): Clear the existing index and reset it in the result for loop. The air_quality_pm25_long.csv data set provides \(PM_{25}\) It seems that this does indeed work as well, although I thought I had already tried this. We Note: If the data frame column is matched. Note the index values on the other For creating Data frames we will be using numpy and pandas. be very expensive relative to the actual data concatenation. in the air_quality (left) table, i.e.FR04014, BETR801 and London Euler: A baby on his lap, a cat on his back thats how he wrote his immortal works (origin?). In this article, you'll learn Pandas concat() tricks to deal with the following common problems: Example 2: Concatenate two DataFrames with different columns. by setting the ignore_index option to True. Hosted by OVHcloud. axis=0 to concat along rows, axis=1 to concat along columns. In this tutorial, you'll learn how and when to combine your data in pandas with: merge () for combining data on common columns or indices. function. Label the index keys you create with the names option. pd.concat ValueError: Shape of passed values is _jieru_liu-. By using our site, you Difficulties with estimation of epsilon-delta limit proof, How to tell which packages are held back due to phased updates, Identify those arcade games from a 1983 Brazilian music video. More info can be gotten here. How to combine data from multiple tables. A faster implementation will require NumPy. For example: add name Class to the outermost index we just created. How to Concatenate Column Values in Pandas DataFrame? By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. How do I get the row count of a Pandas DataFrame? A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. Where does this (supposedly) Gibson quote come from? The dataframe I am working with is quite large. Then, the resulting DataFrame index will be labeled with 0, , n-1. Can anybody help me? Save. Connect and share knowledge within a single location that is structured and easy to search. How to Convert a List to a Tuple in Python, Count the Number of Times an Item Appears in a List Python, Replace All Instances of Characters in a String Python. Let's merge the two data frames with different columns. Pull the data out of the dataframe using numpy.ndarrays, concatenate them in numpy, and make a dataframe out of it again: This solution requires more resources, so I would opt for the first one. pandas.concat () function concatenates the two DataFrames and returns a new dataframe with the new columns as well. Merge acts like a SQL join, where you are looking for overlapping rows and getting back a single row for each overlapping row, where outer returns all records from both dataframe, but if there is overlapping rows base join condtion, then it will produce one row. Step 3: Union Pandas DataFrames using Concat. What is the point of Thrower's Bandolier? Howerver concat can achieve better performance if few columns are involved. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Selecting multiple columns in a Pandas dataframe. Add the station coordinates, provided by the stations metadata table, to the corresponding rows in the measurements table. pd.concat([df1,df2]) . The 1st DataFrame would contain this set of numbers: data1 = {'Set1': [55,22,11,77,33]} df1 = pd.DataFrame(data1, columns= ['Set1']) While the 2nd DataFrame would contain this set of numbers: How Intuit democratizes AI development across teams through reusability. How can I combine these columns in this dataframe? Example 1: To add an identifier column, we need to specify the identifiers as a list for the argument "keys" in concat () function, which creates a new multi-indexed dataframe with two dataframes concatenated. This is useful if you are Count of bit different in each cell between . 0 2019-06-21 00:00:00+00:00 FR04014 no2 20.0, 1 2019-06-20 23:00:00+00:00 FR04014 no2 21.8, 2 2019-06-20 22:00:00+00:00 FR04014 no2 26.5, 3 2019-06-20 21:00:00+00:00 FR04014 no2 24.9, 4 2019-06-20 20:00:00+00:00 FR04014 no2 21.4, 0 2019-06-18 06:00:00+00:00 BETR801 pm25 18.0, 1 2019-06-17 08:00:00+00:00 BETR801 pm25 6.5, 2 2019-06-17 07:00:00+00:00 BETR801 pm25 18.5, 3 2019-06-17 06:00:00+00:00 BETR801 pm25 16.0, 4 2019-06-17 05:00:00+00:00 BETR801 pm25 7.5, 'Shape of the ``air_quality_pm25`` table: ', Shape of the ``air_quality_pm25`` table: (1110, 4), 'Shape of the ``air_quality_no2`` table: ', Shape of the ``air_quality_no2`` table: (2068, 4), 'Shape of the resulting ``air_quality`` table: ', Shape of the resulting ``air_quality`` table: (3178, 4), date.utc location parameter value, 2067 2019-05-07 01:00:00+00:00 London Westminster no2 23.0, 1003 2019-05-07 01:00:00+00:00 FR04014 no2 25.0, 100 2019-05-07 01:00:00+00:00 BETR801 pm25 12.5, 1098 2019-05-07 01:00:00+00:00 BETR801 no2 50.5, 1109 2019-05-07 01:00:00+00:00 London Westminster pm25 8.0, PM25 0 2019-06-18 06:00:00+00:00 BETR801 pm25 18.0, location coordinates.latitude coordinates.longitude, 0 BELAL01 51.23619 4.38522, 1 BELHB23 51.17030 4.34100, 2 BELLD01 51.10998 5.00486, 3 BELLD02 51.12038 5.02155, 4 BELR833 51.32766 4.36226, 0 2019-05-07 01:00:00+00:00 -0.13193, 1 2019-05-07 01:00:00+00:00 2.39390, 2 2019-05-07 01:00:00+00:00 2.39390, 3 2019-05-07 01:00:00+00:00 4.43182, 4 2019-05-07 01:00:00+00:00 4.43182, id description name, 0 bc Black Carbon BC, 1 co Carbon Monoxide CO, 2 no2 Nitrogen Dioxide NO2, 3 o3 Ozone O3, 4 pm10 Particulate matter less than 10 micrometers in PM10.